cpworkcard_tracking_raw

Pipelined Data Sets > Symitar > cpworkcard_tracking_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
cpworkcardtrackinguuid	This field stores a JH Platform unique identifier for a cp workcard tracking record	NULLABLE	STRING
accountnumber	This field stores the Symitar account number (membership account number)	NULLABLE	STRING
cpworkcardlocator	This field stores the cp workcard locator	NULLABLE	STRING
cpworkcardtrackingkey	Internal use only; SSDB field	NULLABLE	INTEGER
cpworkcardkey	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
type	This field stores a code that indicates how you use the Collection Tracking record	NULLABLE	INTEGER
id	This field stores the ID of a Share or Loan record (depending on the entry in the ID Type field) referenced by the Collection Tracking record	NULLABLE	STRING
idtype	his field identifies the type of record specified by the ID field	NULLABLE	INTEGER
userid	This field stores the user number of the user who created the Collection Tracking record	NULLABLE	INTEGER
fmlastdate	This field stores the date file maintenance was last performed on the Collection Tracking record	NULLABLE	DATE
creationdate	This field stores the current system date when you create the Collection Tracking record	NULLABLE	DATE
creationtime	This field stores the current system time (HHMM) when you create the Collection Tracking record	NULLABLE	INTEGER
expiredate	This field stores an expiration date for the Collection Tracking record	NULLABLE	DATE
trackingcode	This field stores a credit union-defined code to further identify the purpose of the Collection Tracking record	NULLABLE	INTEGER
usernumber1	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber2	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber3	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber4	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber5	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber6	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber7	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber8	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber9	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber10	These fields store any credit union-defined number	NULLABLE	INTEGER
userchar1	These fields store any credit union-defined character data	NULLABLE	STRING
userchar2	These fields store any credit union-defined character data	NULLABLE	STRING
userchar3	These fields store any credit union-defined character data	NULLABLE	STRING
userchar4	These fields store any credit union-defined character data	NULLABLE	STRING
userchar5	These fields store any credit union-defined character data	NULLABLE	STRING
userchar6	These fields store any credit union-defined character data	NULLABLE	STRING
userchar7	These fields store any credit union-defined character data	NULLABLE	STRING
userchar8	These fields store any credit union-defined character data	NULLABLE	STRING
userchar9	These fields store any credit union-defined character data	NULLABLE	STRING
userchar10	These fields store any credit union-defined character data	NULLABLE	STRING
useramount1	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount2	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount3	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount4	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount5	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount6	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount7	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount8	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount9	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount10	These fields store any credit union-defined amount	NULLABLE	NUMERIC
usercode1	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode2	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode3	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode4	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode5	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode6	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode7	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode8	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode9	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode10	These fields store any credit union-defined code	NULLABLE	INTEGER
userdate1	These fields store any credit union-defined date	NULLABLE	DATE
userdate2	These fields store any credit union-defined date	NULLABLE	DATE
userdate3	These fields store any credit union-defined date	NULLABLE	DATE
userdate4	These fields store any credit union-defined date	NULLABLE	DATE
userdate5	These fields store any credit union-defined date	NULLABLE	DATE
userdate6	These fields store any credit union-defined date	NULLABLE	DATE
userdate7	These fields store any credit union-defined date	NULLABLE	DATE
userdate8	These fields store any credit union-defined date	NULLABLE	DATE
userdate9	These fields store any credit union-defined date	NULLABLE	DATE
userdate10	These fields store any credit union-defined date	NULLABLE	DATE
userrate1	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate2	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate3	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate4	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate5	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate6	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate7	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate8	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate9	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate10	These fields store any credit union-defined rate	NULLABLE	NUMERIC
locator	This field value in each record is unique for each member account	NULLABLE	INTEGER
usernumber11	These fields store any credit union-defined number for tracking types 30-99	NULLABLE	INTEGER
usernumber12	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber13	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber14	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber15	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber16	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber17	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber18	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber19	These fields store any credit union-defined number	NULLABLE	INTEGER
usernumber20	These fields store any credit union-defined number for tracking types 30-99	NULLABLE	INTEGER
userchar11	These fields store any credit union-defined character data for tracking types 30-99	NULLABLE	STRING
userchar12	These fields store any credit union-defined character data	NULLABLE	STRING
userchar13	These fields store any credit union-defined character data	NULLABLE	STRING
userchar14	These fields store any credit union-defined character data	NULLABLE	STRING
userchar15	These fields store any credit union-defined character data	NULLABLE	STRING
userchar16	These fields store any credit union-defined character data	NULLABLE	STRING
userchar17	These fields store any credit union-defined character data	NULLABLE	STRING
userchar18	These fields store any credit union-defined character data	NULLABLE	STRING
userchar19	These fields store any credit union-defined character data	NULLABLE	STRING
userchar20	These fields store any credit union-defined character data for tracking types 30-99	NULLABLE	STRING
useramount11	These fields store any credit union-defined amount for tracking types 30-99	NULLABLE	NUMERIC
useramount12	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount13	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount14	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount15	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount16	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount17	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount18	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount19	These fields store any credit union-defined amount	NULLABLE	NUMERIC
useramount20	These fields store any credit union-defined amount for tracking types 30-99	NULLABLE	NUMERIC
usercode11	These fields store any credit union-defined code for tracking types 30-99	NULLABLE	INTEGER
usercode12	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode13	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode14	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode15	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode16	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode17	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode18	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode19	These fields store any credit union-defined code	NULLABLE	INTEGER
usercode20	These fields store any credit union-defined code for tracking types 30-99	NULLABLE	INTEGER
userdate11	These fields store any credit union-defined date for tracking types 30-99	NULLABLE	DATE
userdate12	These fields store any credit union-defined date	NULLABLE	DATE
userdate13	These fields store any credit union-defined date	NULLABLE	DATE
userdate14	These fields store any credit union-defined date	NULLABLE	DATE
userdate15	These fields store any credit union-defined date	NULLABLE	DATE
userdate16	These fields store any credit union-defined date	NULLABLE	DATE
userdate17	These fields store any credit union-defined date	NULLABLE	DATE
userdate18	These fields store any credit union-defined date	NULLABLE	DATE
userdate19	These fields store any credit union-defined date	NULLABLE	DATE
userdate20	These fields store any credit union-defined date for tracking types 30-99	NULLABLE	DATE
userrate11	These fields store any credit union-defined rate for tracking types 30-99	NULLABLE	NUMERIC
userrate12	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate13	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate14	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate15	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate16	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate17	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate18	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate19	These fields store any credit union-defined rate	NULLABLE	NUMERIC
userrate20	These fields store any credit union-defined rate for tracking types 30-99	NULLABLE	NUMERIC
recordchangedate	This field stores the system date when you create, change, or save a 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