GP_PKG_IDTRANSACTION_NBREMPLIDEMPL_RCDBGN_DTPIN_TAKE_NUMEND_DTGP_ABS_NRP_SSAD(SQL Table) |
Index Back |
|---|---|
Absence SS Top RecordThis record is used as the main shadow record for absence self service. In order to allow the HCM Approval Framework to link to absence self service via the transaction keys as required, and to allow the SS users to edit an existing transaction by modifying the keys, we have to keep the original transaction keys the same but track the new key changes in the "Original_KeyName" fields |
| # | 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 | 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. |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | BGN_DT |
Date(10) | DATE | Begin Date |
| 6 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 7 | END_DT |
Date(10) | DATE | end date |
| 8 | ORIG_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Originating Emplid |
| 9 | ORIG_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 10 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
| 11 | ORIG_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 12 | ORIG_END_DT | Date(10) | DATE | Unadjusted End Date |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 14 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |