TRANSACTIONIDEOAWDEFN_IDEMPLIDEMPL_RCDDURSEQ_NBRPUNCH_TYPE0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
TL_NRP_APP_VW(SQL View) |
Index Back |
|---|---|
TL approvals line rec NRP VWTL approvals line record for reported time NRP VW |
| SELECT TRANSACTIONID ,EOAWDEFN_ID ,EMPLID ,EMPL_RCD ,DUR ,SEQ_NBR ,PUNCH_TYPE ,BGN_DT ,PIN_TAKE_NUM + 50000000 ,END_DT ,TRANSACTION_NBR ,TL_APPR_RPT_ADHOC ,TL_APPR_RPT_GRP1 ,TL_APPR_RPT_GRP2 FROM PS_TL_APP_RPT_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTIONID |
Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 2 | EOAWDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | PUNCH_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer |
| 8 | BGN_DT | Date(10) | DATE | Begin Date |
| 9 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 10 | END_DT | Date(10) | DATE | end date |
| 11 | 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. |
| 12 | TL_APPR_RPT_ADHOC | Character(7) | VARCHAR2(7) NOT NULL | TL adhoc approval group for reported time |
| 13 | TL_APPR_RPT_GRP1 | Character(7) | VARCHAR2(7) NOT NULL | TL Approval Group on the workgroup and TRC page for reported time approvals |
| 14 | TL_APPR_RPT_GRP2 | Character(7) | VARCHAR2(7) NOT NULL | TL Approval Group on the workgroup and TRC page for reported time approvals |