TL_NRP_APP_AD

(SQL Table)
Index Back

TL approvals line rec

TL approvals line record for reported time

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
7 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
8 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
9 BGN_DT Date(10) DATE Begin Date
10 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
11 END_DT Date(10) DATE end date
12 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
13 TL_APPR_RPT_ADHOC Character(7) VARCHAR2(7) NOT NULL TL adhoc approval group for reported time
14 TL_APPR_RPT_GRP1 Character(7) VARCHAR2(7) NOT NULL TL Approval Group on the workgroup and TRC page for reported time approvals
15 TL_APPR_RPT_GRP2 Character(7) VARCHAR2(7) NOT NULL TL Approval Group on the workgroup and TRC page for reported time approvals