savings_analysis_raw
Pipelined Data Sets
>
Symitar
>
savings_analysis_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| eventtime | Internal use only | NULLABLE | INTEGER | |
| sourcetype | Internal use only; SSDB field | NULLABLE | STRING | |
| operation | Internal use only; SSDB field | NULLABLE | STRING | |
| extractdate | Internal use only | NULLABLE | DATE | |
| processdatetime | Internal use only; SSDB field | NULLABLE | TIMESTAMP | |
| savingsanalysisuuid | This field stores a JH Platform unique identifier for a savings analysis | NULLABLE | STRING | |
| savingsuuid | This field stores a JH Platform unique identifier for a savings | NULLABLE | STRING | |
| accountnumber | This field stores the Symitar account number (membership account number) | NULLABLE | STRING | |
| savingsid | This field stores the 4 digit Share ID | NULLABLE | STRING | |
| savingsanalysiskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| savingskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| accountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| symdate | Internal use only; SSDB field | NULLABLE | INTEGER | |
| systemcreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odscreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sym | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odsdeleteflag | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| plan | This field indicates which Analysis Plan group in the Analysis Plan Parameters is associated with this record | NULLABLE | INTEGER | |
| statementdate | The Statement Cutoff Processing batch program sets this field to the current system date then creates a new Share Analysis record for the selected group that has the counters set to 0 | NULLABLE | DATE | |
| statementprevdate | The information in this record can be used for fee posting and producing analysis statements for the specified statement group | NULLABLE | DATE | |
| statementgroup | The information in this record can be used for fee posting and producing analysis statements for the specified statement groups | NULLABLE | INTEGER | |
| locator | This field value in each record is unique for each member account | NULLABLE | INTEGER | |
| counter_1 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_2 | This counter is used to track teller deposit transactions with adjustments | NULLABLE | INTEGER | |
| counter_3 | This counter is used to track returned deposits | NULLABLE | INTEGER | |
| counter_4 | This counter is used to track draft transactions (transactions using the DR transaction code, DRAFTPOST, ACHPOST, ON US, etc.) | NULLABLE | INTEGER | |
| counter_5 | This counter is used to track bulk deposits (transactions using the BK transaction code) | NULLABLE | INTEGER | |
| counter_6 | This counter is used to track the number of change orders | NULLABLE | INTEGER | |
| counter_7 | This counter is used to track the number of NSF batch postings | NULLABLE | INTEGER | |
| counter_8 | This counter is used to track the number of sweep count transactions | NULLABLE | INTEGER | |
| counter_9 | This counter is used to track the number of stop payment transactions (SP transaction code, audio, home banking) | NULLABLE | INTEGER | |
| counter_10 | This counter is used to track the number of account printouts | NULLABLE | INTEGER | |
| counter_11 | This counter is used to track the number of statement balances | NULLABLE | INTEGER | |
| counter_12 | This counter is used to track statement balances | NULLABLE | INTEGER | |
| counter_13 | This counter is used to track check copies | NULLABLE | INTEGER | |
| counter_14 | This counter is used to track checks disbursed from the primary printer (transactions using the KD and KS transaction codes) | NULLABLE | INTEGER | |
| counter_15 | This counter is used to track checks disbursed from the secondary printer (transactions using the KO and KS transaction codes) | NULLABLE | INTEGER | |
| counter_16 | This counter is used to track money order transactions (transactions using the MO transaction code) | NULLABLE | INTEGER | |
| counter_17 | This counter is used to track incoming wire transfers | NULLABLE | INTEGER | |
| counter_18 | This counter is used to track outgoing wire transfers | NULLABLE | INTEGER | |
| counter_19 | This counter is used to track transfers to cover overdrafts (batch postings) | NULLABLE | INTEGER | |
| counter_20 | This counter is used to track courtesy pay transactions | NULLABLE | INTEGER | |
| counter_21 | This counter is used to track ACH debits when they post | NULLABLE | INTEGER | |
| counter_22 | This counter is used to track ACH credits when they post | NULLABLE | INTEGER | |
| counter_23 | This counter is used to track ACH debits when you run ACH Origination | NULLABLE | INTEGER | |
| counter_24 | This counter is used to track ACH credits when you run ACH Origination | NULLABLE | INTEGER | |
| counter_25 | This counter is used to track checks received and checks cashed (transactions using the KR and KC transaction codes) | NULLABLE | INTEGER | |
| counter_26 | This counter is used to track on-us items drawn on an analyzed share and disbursed from an account (transactions using the ON transaction code) | NULLABLE | INTEGER | |
| counter_27 | This counter is used to track lob visits (teller transactions) | NULLABLE | INTEGER | |
| counter_28 | This counter is used to track loose coin bulk deposits (transactions using the BK transaction code) | NULLABLE | INTEGER | |
| counter_29 | This counter is used to track rolled coin bulk deposits (transactions using the BK transaction code) | NULLABLE | INTEGER | |
| counter_30 | This counter is used to track loose currency bulk deposits (transactions using the BK transaction code) | NULLABLE | INTEGER | |
| counter_31 | This counter is used to track strapped currency bulk deposits (transactions using the BK transaction code) | NULLABLE | INTEGER | |
| counter_32 | This counter is used to track on-us items drawn on a different account and deposited to an analyzed share (transactions using the ON transaction code) | NULLABLE | INTEGER | |
| counter_33 | These counters are reserved for future use | NULLABLE | INTEGER | |
| counter_34 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_35 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_36 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_37 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_38 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_39 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_40 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_41 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_42 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_43 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_44 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_45 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_46 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_47 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_48 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_49 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_50 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_51 | These counters are defined by the financial institution in the Analysis Global Parameters in the Parameter Manager | NULLABLE | INTEGER | |
| counter_52 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_53 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_54 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_55 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_56 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_57 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_58 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_59 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_60 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_61 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_62 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_63 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_64 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_65 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_66 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_67 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_68 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_69 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_70 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_71 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_72 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_73 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_74 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_75 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_76 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_77 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_78 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_79 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_80 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_81 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_82 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_83 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_84 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_85 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_86 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_87 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_88 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_89 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_90 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_91 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_92 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_93 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_94 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_95 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_96 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_97 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_98 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_99 | This counter is used to track teller deposit (transactions using the SD transaction code) and batch deposit transactions | NULLABLE | INTEGER | |
| counter_100 | These counters are defined by the financial institution in the Analysis Global Parameters in the Parameter Manager | NULLABLE | INTEGER | |
| cashamttotal | This field stores the monthly total of CD, CR, ATM, FR and FD transactions on analyzed accounts | NULLABLE | NUMERIC | |
| recordchangedate | This field stores the system date in the Record Change Date field when you create, change, or save the Share Analysis record | NULLABLE | DATE |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026