check_raw

Pipelined Data Sets > Symitar > check_raw

Column name	Description	Mode	Type
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
checkuuid	This field stores a JH Platform unique identifier for a check	NULLABLE	STRING
checkkey	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
accountcode	This field stores the GL checking account on which the check is drawn	NULLABLE	STRING
number	The system stores the identification number printed on the check	NULLABLE	STRING
payee_1	This field stores the first line of payee name and address information as it appears on the check	NULLABLE	STRING
payee_2	This field stores the second line of payee name and address information as it appears on the check	NULLABLE	STRING
payee_3	This field stores the third line of payee name and address information as it appears on the check	NULLABLE	STRING
payee_4	This field stores the fourth line of payee name and address information as it appears on the check	NULLABLE	STRING
payee_5	This field stores the fifth line of payee name and address information as it appears on the check	NULLABLE	STRING
postdate	The system stores the current system date in this field when the check posts to the General Ledger	NULLABLE	DATE
sequencenumber	The system stores a sequence number to the transaction in which the check was posted	NULLABLE	INTEGER
issuedate	This field stores the date that the value in the Status field for the check was changed to (1) Issued	NULLABLE	DATE
reconciliationdate	This field stores the date that the value in the Status field for the check was changed to (3) Reconciled	NULLABLE	DATE
status	This field stores a code that specifies the status of this check	NULLABLE	INTEGER
accountnumber	If the check is related to a member account, this field stores the member's account number	NULLABLE	STRING
idtype	If the check is related to a member account, this field stores a code that indicates the type of member account share or loan related to this Check record	NULLABLE	INTEGER
id	If the check is related to a member account, this field specifies the ID of the member share or loan affected by the check	NULLABLE	STRING
reference	This field stores the purpose of the check or other reference information, such as the member for whom a first-party check is being issued through SymConnect	NULLABLE	STRING
amount	This field stores the amount of the check	NULLABLE	NUMERIC
branch	This field stores a code that specifies the credit union branch related to this check	NULLABLE	INTEGER
source	This field stores a code that indicates the source of the check	NULLABLE	INTEGER
voiddate	This field stores the date that the value in the Status field for the check was changed to (2) Voided	NULLABLE	DATE
stoppmtdate	This field stores the date that the value in the Status field for the check was changed to (4) Stop Pay	NULLABLE	DATE
reference2	This field stores reference data combined from other records that appears on the line below the original reference on the check	NULLABLE	STRING
tracernumber	This field stores a tracer number to use during check reconciliation	NULLABLE	STRING
sourceglcode	This field stores a code that indicates how to disburse the check	NULLABLE	INTEGER
escheatdate	This field stores the date that the value in the Status field for the check was changed to (5) Escheated	NULLABLE	DATE
checknumberassigned	This field stores a code that indicates whether the check number has been assigned	NULLABLE	INTEGER
globalsequencedate	The system stores the date in this field that any process created this record	NULLABLE	DATE
globalsequence	The system stores a unique number for each global sequence in this field for any process that creates this record	NULLABLE	INTEGER
reference3	This field stores extra reference data that exceeds the length of the Reference 2 field	NULLABLE	STRING
fmlastpurgedate	This field stores the date on which you last purged file maintenance history for the Check records with the Purge Transaction Processing batch program	NULLABLE	DATE
recordchangedate	This field stores the system date in this field when you create, change, or save the Check record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the 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.

Please ignore this field

Did this page help you?

Last updated Tue Sep 15 2026