TL_TTHRS_TAO

(SQL Table)
Index Back

Work Table for TCD Total Hours

Temp Table for population of Total Hours per Time Reporter, per Time Period to be sent to TCDs.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
3 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
7 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process
8 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
9 TCD_NETWORK_ID Character(20) VARCHAR2(20) NOT NULL Network ID
10 TCD_NODE_ID Character(20) VARCHAR2(20) NOT NULL Terminal ID
11 BADGE_NBR Character(20) VARCHAR2(20) NOT NULL Badge Number
12 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,