jhcldr_raw

Core Schemas > Silverlake > jhcldr_raw

Column name	Description	Mode	Type	Length
__op	Contains the operation type. Values are I for insert, U for update, D for delete.	REQUIRED	STRING
__op_ts	operation timestamp added by export code	REQUIRED	TIMESTAMP
__uid	The Unique ID of this entry. Data, UUID, or GUID	REQUIRED	STRING
__ver	Mapping and Schema Version	REQUIRED	INTEGER
cdate	Current processing date \| DEC(6,0)	NULLABLE	INTEGER	6
cwday	Day of week \| CHAR(9)	NULLABLE	STRING	9
cmonth	Month \| CHAR(9)	NULLABLE	STRING	9
proday	Processing day flag \| CHAR(1)	NULLABLE	STRING	1
prostm	Process Stmts \| CHAR(1)	NULLABLE	STRING	1
stcyc1	Statement cycle 1 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst1	Print stmts cycle 1 \| CHAR(1)	NULLABLE	STRING	1
svchg1	S/C cycle 1 \| CHAR(1)	NULLABLE	STRING	1
crint1	Credit Int cycle 1 \| CHAR(1)	NULLABLE	STRING	1
stcyc2	Statement cycle 2 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst2	Print stmts cycle 2 \| CHAR(1)	NULLABLE	STRING	1
svchg2	S/C cycle 2 \| CHAR(1)	NULLABLE	STRING	1
crint2	Credit Int cycle 2 \| CHAR(1)	NULLABLE	STRING	1
stcyc3	Statement cycle 3 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst3	Print stmts cycle 3 \| CHAR(1)	NULLABLE	STRING	1
svchg3	S/C cycle 3 \| CHAR(1)	NULLABLE	STRING	1
crint3	Credit Int cycle 3 \| CHAR(1)	NULLABLE	STRING	1
stcyc4	Statement cycle 4 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst4	Print stmts cycle 4 \| CHAR(1)	NULLABLE	STRING	1
svchg4	S/C cycle 4 \| CHAR(1)	NULLABLE	STRING	1
crint4	Credit Int cycle 4 \| CHAR(1)	NULLABLE	STRING	1
stcyc5	Statement cycle 5 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst5	Print stmts cycle 5 \| CHAR(1)	NULLABLE	STRING	1
svchg5	S/C cycle 5 \| CHAR(1)	NULLABLE	STRING	1
crint5	Credit Int cycle 5 \| CHAR(1)	NULLABLE	STRING	1
stcyc6	Statement cycle 6 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst6	Print stmts cycle 6 \| CHAR(1)	NULLABLE	STRING	1
svchg6	S/C cycle 6 \| CHAR(1)	NULLABLE	STRING	1
crint6	Credit Int cycle 6 \| CHAR(1)	NULLABLE	STRING	1
stcyc7	Statement cycle 7 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst7	Print stmts cycle 7 \| CHAR(1)	NULLABLE	STRING	1
svchg7	S/C cycle 7 \| CHAR(1)	NULLABLE	STRING	1
crint7	Credit Int cycle 7 \| CHAR(1)	NULLABLE	STRING	1
stcyc8	Statement cycle 8 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst8	Print stmts cycle 8 \| CHAR(1)	NULLABLE	STRING	1
svchg8	S/C cycle 8 \| CHAR(1)	NULLABLE	STRING	1
crint8	Credit Int cycle 8 \| CHAR(1)	NULLABLE	STRING	1
stcyc9	Statement cycle 9 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst9	Print stmts cycle 9 \| CHAR(1)	NULLABLE	STRING	1
svchg9	S/C cycle 9 \| CHAR(1)	NULLABLE	STRING	1
crint9	Credit Int cycle 9 \| CHAR(1)	NULLABLE	STRING	1
stcyc0	Statement cycle 10 \| DEC(2,0)	NULLABLE	INTEGER	2
prtst0	Print stmts cycle 10 \| CHAR(1)	NULLABLE	STRING	1
svchg0	S/C cycle 10 \| CHAR(1)	NULLABLE	STRING	1
crint0	Credit Int cycle 10 \| CHAR(1)	NULLABLE	STRING	1
stcy11	Statement cycle 11 \| DEC(2,0)	NULLABLE	INTEGER	2
prts11	Print stmts cycle 11 \| CHAR(1)	NULLABLE	STRING	1
svch11	S/C cycle 11 \| CHAR(1)	NULLABLE	STRING	1
crin11	Credit Int cycle 11 \| CHAR(1)	NULLABLE	STRING	1
stcy12	Statement cycle 12 \| DEC(2,0)	NULLABLE	INTEGER	2
prts12	Print stmts cycle 12 \| CHAR(1)	NULLABLE	STRING	1
svch12	S/C cycle 12 \| CHAR(1)	NULLABLE	STRING	1
crin12	Credit Int cycle 12 \| CHAR(1)	NULLABLE	STRING	1
stcy13	Statement cycle 13 \| DEC(2,0)	NULLABLE	INTEGER	2
prts13	Print stmts cycle 13 \| CHAR(1)	NULLABLE	STRING	1
svch13	S/C cycle 13 \| CHAR(1)	NULLABLE	STRING	1
crin13	Credit Int cycle 13 \| CHAR(1)	NULLABLE	STRING	1
stcy14	Statement cycle 14 \| DEC(2,0)	NULLABLE	INTEGER	2
prts14	Print stmts cycle 14 \| CHAR(1)	NULLABLE	STRING	1
svch14	S/C cycle 14 \| CHAR(1)	NULLABLE	STRING	1
crin14	Credit Int cycle 14 \| CHAR(1)	NULLABLE	STRING	1
stcy15	Statement cycle 15 \| DEC(2,0)	NULLABLE	INTEGER	2
prts15	Print stmts cycle 15 \| CHAR(1)	NULLABLE	STRING	1
svch15	S/C cycle 15 \| CHAR(1)	NULLABLE	STRING	1
crin15	Credit Int cycle 15 \| CHAR(1)	NULLABLE	STRING	1
stcy16	Statement cycle 16 \| DEC(2,0)	NULLABLE	INTEGER	2
prts16	Print stmts cycle 16 \| CHAR(1)	NULLABLE	STRING	1
svch16	S/C cycle 16 \| CHAR(1)	NULLABLE	STRING	1
crin16	Credit Int cycle 16 \| CHAR(1)	NULLABLE	STRING	1
stcy17	Statement cycle 17 \| DEC(2,0)	NULLABLE	INTEGER	2
prts17	Print stmts cycle 17 \| CHAR(1)	NULLABLE	STRING	1
svch17	S/C cycle 17 \| CHAR(1)	NULLABLE	STRING	1
crin17	Credit Int cycle 17 \| CHAR(1)	NULLABLE	STRING	1
stcy18	Statement cycle 18 \| DEC(2,0)	NULLABLE	INTEGER	2
prts18	Print stmts cycle 18 \| CHAR(1)	NULLABLE	STRING	1
svch18	S/C cycle 18 \| CHAR(1)	NULLABLE	STRING	1
crin18	Credit Int cycle 18 \| CHAR(1)	NULLABLE	STRING	1
stcy19	Statement cycle 19 \| DEC(2,0)	NULLABLE	INTEGER	2
prts19	Print stmts cycle 19 \| CHAR(1)	NULLABLE	STRING	1
svch19	S/C cycle 19 \| CHAR(1)	NULLABLE	STRING	1
crin19	Credit Int cycle 19 \| CHAR(1)	NULLABLE	STRING	1
stcy20	Statement cycle 20 \| DEC(2,0)	NULLABLE	INTEGER	2
prts20	Print stmts cycle 20 \| CHAR(1)	NULLABLE	STRING	1
svch20	S/C cycle 20 \| CHAR(1)	NULLABLE	STRING	1
crin20	Credit Int cycle 20 \| CHAR(1)	NULLABLE	STRING	1
stcy21	Statement cycle 21 \| DEC(2,0)	NULLABLE	INTEGER	2
prts21	Print stmts cycle 21 \| CHAR(1)	NULLABLE	STRING	1
svch21	S/C cycle 21 \| CHAR(1)	NULLABLE	STRING	1
crin21	Credit Int cycle 21 \| CHAR(1)	NULLABLE	STRING	1
stcy22	Statement cycle 22 \| DEC(2,0)	NULLABLE	INTEGER	2
prts22	Print stmts cycle 22 \| CHAR(1)	NULLABLE	STRING	1
svch22	S/C cycle 22 \| CHAR(1)	NULLABLE	STRING	1
crin22	Credit Int cycle 22 \| CHAR(1)	NULLABLE	STRING	1
stcy23	Statement cycle 23 \| DEC(2,0)	NULLABLE	INTEGER	2
prts23	Print stmts cycle 23 \| CHAR(1)	NULLABLE	STRING	1
svch23	S/C cycle 23 \| CHAR(1)	NULLABLE	STRING	1
crin23	Credit Int cycle 23 \| CHAR(1)	NULLABLE	STRING	1
stcy24	Statement cycle 24 \| DEC(2,0)	NULLABLE	INTEGER	2
prts24	Print stmts cycle 24 \| CHAR(1)	NULLABLE	STRING	1
svch24	S/C cycle 24 \| CHAR(1)	NULLABLE	STRING	1
crin24	Credit Int cycle 24 \| CHAR(1)	NULLABLE	STRING	1
stcy25	Statement cycle 25 \| DEC(2,0)	NULLABLE	INTEGER	2
prts25	Print stmts cycle 25 \| CHAR(1)	NULLABLE	STRING	1
svch25	S/C cycle 25 \| CHAR(1)	NULLABLE	STRING	1
crin25	Credit Int cycle 25 \| CHAR(1)	NULLABLE	STRING	1
stcy26	Statement cycle 26 \| DEC(2,0)	NULLABLE	INTEGER	2
prts26	Print stmts cycle 26 \| CHAR(1)	NULLABLE	STRING	1
svch26	S/C cycle 26 \| CHAR(1)	NULLABLE	STRING	1
crin26	Credit Int cycle 26 \| CHAR(1)	NULLABLE	STRING	1
stcy27	Statement cycle 27 \| DEC(2,0)	NULLABLE	INTEGER	2
prts27	Print stmts cycle 27 \| CHAR(1)	NULLABLE	STRING	1
svch27	S/C cycle 27 \| CHAR(1)	NULLABLE	STRING	1
crin27	Credit Int cycle 27 \| CHAR(1)	NULLABLE	STRING	1
stcy28	Statement cycle 28 \| DEC(2,0)	NULLABLE	INTEGER	2
prts28	Print stmts cycle 28 \| CHAR(1)	NULLABLE	STRING	1
svch28	S/C cycle 28 \| CHAR(1)	NULLABLE	STRING	1
crin28	Credit Int cycle 28 \| CHAR(1)	NULLABLE	STRING	1
stcy29	Statement cycle 29 \| DEC(2,0)	NULLABLE	INTEGER	2
prts29	Print stmts cycle 29 \| CHAR(1)	NULLABLE	STRING	1
svch29	S/C cycle 29 \| CHAR(1)	NULLABLE	STRING	1
crin29	Credit Int cycle 29 \| CHAR(1)	NULLABLE	STRING	1
stcy30	Statement cycle 30 \| DEC(2,0)	NULLABLE	INTEGER	2
prts30	Print stmts cycle 30 \| CHAR(1)	NULLABLE	STRING	1
svch30	S/C cycle 30 \| CHAR(1)	NULLABLE	STRING	1
crin30	Credit Int cycle 30 \| CHAR(1)	NULLABLE	STRING	1
stcy31	Statement cycle 31 \| DEC(2,0)	NULLABLE	INTEGER	2
prts31	Print stmts cycle 31 \| CHAR(1)	NULLABLE	STRING	1
svch31	S/C cycle 31 \| CHAR(1)	NULLABLE	STRING	1
crin31	Credit Int cycle 31 \| CHAR(1)	NULLABLE	STRING	1
stcy32	Statement cycle 32 \| DEC(2,0)	NULLABLE	INTEGER	2
prts32	Print stmts cycle 32 \| CHAR(1)	NULLABLE	STRING	1
svch32	S/C cycle 32 \| CHAR(1)	NULLABLE	STRING	1
crin32	Credit Int cycle 32 \| CHAR(1)	NULLABLE	STRING	1
stcy33	Statement cycle 33 \| DEC(2,0)	NULLABLE	INTEGER	2
prts33	Print stmts cycle 33 \| CHAR(1)	NULLABLE	STRING	1
svch33	S/C cycle 33 \| CHAR(1)	NULLABLE	STRING	1
crin33	Credit Int cycle 33 \| CHAR(1)	NULLABLE	STRING	1
stcy34	Statement cycle 34 \| DEC(2,0)	NULLABLE	INTEGER	2
prts34	Print stmts cycle 34 \| CHAR(1)	NULLABLE	STRING	1
svch34	S/C cycle 34 \| CHAR(1)	NULLABLE	STRING	1
crin34	Credit Int cycle 34 \| CHAR(1)	NULLABLE	STRING	1
stcy35	Statement cycle 35 \| DEC(2,0)	NULLABLE	INTEGER	2
prts35	Print stmts cycle 35 \| CHAR(1)	NULLABLE	STRING	1
svch35	S/C cycle 35 \| CHAR(1)	NULLABLE	STRING	1
crin35	Credit Int cycle 35 \| CHAR(1)	NULLABLE	STRING	1
stcy36	Statement cycle 36 \| DEC(2,0)	NULLABLE	INTEGER	2
prts36	Print stmts cycle 36 \| CHAR(1)	NULLABLE	STRING	1
svch36	S/C cycle 36 \| CHAR(1)	NULLABLE	STRING	1
crin36	Credit Int cycle 36 \| CHAR(1)	NULLABLE	STRING	1
stcy37	Statement cycle 37 \| DEC(2,0)	NULLABLE	INTEGER	2
prts37	Print stmts cycle 37 \| CHAR(1)	NULLABLE	STRING	1
svch37	S/C cycle 37 \| CHAR(1)	NULLABLE	STRING	1
crin37	Credit Int cycle 37 \| CHAR(1)	NULLABLE	STRING	1
stcy38	Statement cycle 38 \| DEC(2,0)	NULLABLE	INTEGER	2
prts38	Print stmts cycle 38 \| CHAR(1)	NULLABLE	STRING	1
svch38	S/C cycle 38 \| CHAR(1)	NULLABLE	STRING	1
crin38	Credit Int cycle 38 \| CHAR(1)	NULLABLE	STRING	1
stcy39	Statement cycle 39 \| DEC(2,0)	NULLABLE	INTEGER	2
prts39	Print stmts cycle 39 \| CHAR(1)	NULLABLE	STRING	1
svch39	S/C cycle 39 \| CHAR(1)	NULLABLE	STRING	1
crin39	Credit Int cycle 39 \| CHAR(1)	NULLABLE	STRING	1
stcy40	Statement cycle 40 \| DEC(2,0)	NULLABLE	INTEGER	2
prts40	Print stmts cycle 40 \| CHAR(1)	NULLABLE	STRING	1
svch40	S/C cycle 40 \| CHAR(1)	NULLABLE	STRING	1
crin40	Credit Int cycle 40 \| CHAR(1)	NULLABLE	STRING	1
detdda	Process DDA Dormant Fees \| CHAR(1)	NULLABLE	STRING	1
detsav	Process SAV Dormant Fees \| CHAR(1)	NULLABLE	STRING	1
detxms	Not used \| CHAR(1)	NULLABLE	STRING	1
endckd	Ending check date \| DEC(7,0)	NULLABLE	INTEGER	7
endck6	Ending check date \| DEC(6,0)	NULLABLE	INTEGER	6
triopt	* \| CHAR(1)	NULLABLE	STRING	1
detcds	* \| CHAR(1)	NULLABLE	STRING	1
detlon	Proces Escrow Int Credit \| CHAR(1)	NULLABLE	STRING	1
detfsb	Process FASB Accrual \| CHAR(1)	NULLABLE	STRING	1
detstm	Process Dealer Stmts \| CHAR(1)	NULLABLE	STRING	1
prtpdr	* \| CHAR(1)	NULLABLE	STRING	1
prtacr	* \| CHAR(1)	NULLABLE	STRING	1
nogltb	* \| DEC(2,0)	NULLABLE	INTEGER	2
noglbs	* \| DEC(2,0)	NULLABLE	INTEGER	2
noglis	* \| DEC(2,0)	NULLABLE	INTEGER	2
noglcs	* \| DEC(2,0)	NULLABLE	INTEGER	2
depsts	Deposits processed \| CHAR(1)	NULLABLE	STRING	1
cdssts	C/D processed \| CHAR(1)	NULLABLE	STRING	1
lonsts	Loans processed \| CHAR(1)	NULLABLE	STRING	1
glests	G/L processed \| CHAR(1)	NULLABLE	STRING	1
ctext	Current date text \| CHAR(20)	NULLABLE	STRING	20
cjdate	Current processing julian date \| DEC(7,0)	NULLABLE	INTEGER	7
prolst	Last processing date \| DEC(6,0)	NULLABLE	INTEGER	6
prjlst	Last processing julian date \| DEC(7,0)	NULLABLE	INTEGER	7
pronxt	Next processing date \| DEC(6,0)	NULLABLE	INTEGER	6
prjnxt	Next processing julian date \| DEC(7,0)	NULLABLE	INTEGER	7
nodltc	Days last to current \| DEC(1,0)	NULLABLE	INTEGER	1
nodctn	Days current to next \| DEC(1,0)	NULLABLE	INTEGER	1
nodrem	Days left in period \| DEC(1,0)	NULLABLE	INTEGER	1
nodadv	Days advanced in period \| DEC(1,0)	NULLABLE	INTEGER	1
nodchk	Days in advance for check print \| DEC(2,0)	NULLABLE	INTEGER	2
holday	Holiday \| CHAR(1)	NULLABLE	STRING	1
ceow	End of week \| CHAR(1)	NULLABLE	STRING	1
ceom	End of month \| CHAR(1)	NULLABLE	STRING	1
ceoq	End of quarter \| CHAR(1)	NULLABLE	STRING	1
ceoy	End of year \| CHAR(1)	NULLABLE	STRING	1
crow	Beginning of week \| CHAR(1)	NULLABLE	STRING	1
crom	Beginning of month \| CHAR(1)	NULLABLE	STRING	1
croq	Beginning of quarter \| CHAR(1)	NULLABLE	STRING	1
croy	Beginning of year \| CHAR(1)	NULLABLE	STRING	1
brdlyc	Delay Before Using Contingency File \| DEC(3,0)	NULLABLE	INTEGER	3
brhlte	Halt EOD when statement not received \| CHAR(1)	NULLABLE	STRING	1

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.

Last updated Thu Dec 12 2024