TRANSACTION_NBREMPLIDEMPL_RCDBGN_DTPIN_TAKE_NUMPrompt Table: GP_PIN_ABSTK_VW
END_DTGP_ABS_SS_DAT(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 | 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. |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | BGN_DT |
Date(10) | DATE | Begin Date |
| 5 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 6 | END_DT |
Date(10) | DATE | end date |
| 7 | ORIG_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Originating Emplid |
| 8 | ORIG_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 9 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
| 10 | ORIG_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 11 | ORIG_END_DT | Date(10) | DATE | Original END_DT before adjust |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 13 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |