TL_NRP_APP_AD(SQL Table) |
Index Back |
---|---|
TL approvals line recTL 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 |