TL_SCHEDULE_MSG

(SQL Table)
Index Back

TCD Time Rprtr Sched Msg Rec

TCD Time Rprtr Sched Msg Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process
3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
4 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
5 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.
6 TCD_NETWORK_ID Character(20) VARCHAR2(20) NOT NULL Network ID
7 TCD_NODE_ID Character(20) VARCHAR2(20) NOT NULL Terminal ID
8 BADGE_NBR Character(20) VARCHAR2(20) NOT NULL Badge Number
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
11 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.
12 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
13 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer