EMPLIDPrompt Table: PERSON
EMPL_RCDGPCH_AB_EXPECT_DT1LETTER_CDPrompt Table: STANDRD_LTR_TBL
LETTER_PRINTED_DTGPCH_AB_LETTRS(SQL Table) |
Index Back |
|---|---|
Absence LettersAbsence Letters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GPCH_AB_EXPECT_DT1 |
Date(10) | DATE NOT NULL | Expected Date of Birth |
| 4 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 5 | GPCH_AB_LST_WRK_DY | Date(10) | DATE | Maternity - Last Work Day |
| 6 | GPCH_AB_BEGIN_DT1 | Date(10) | DATE | Begin Date Maternity |
| 7 | GPCH_AB_END_DT1 | Date(10) | DATE | End Date Maternity |
| 8 | GPCH_AB_BEGIN_DT2 | Date(10) | DATE | Begin Date Educational Leave |
| 9 | GPCH_AB_END_DT2 | Date(10) | DATE | End Date Educational Leave |
| 10 | LETTER_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Letter code
Prompt Table: STANDRD_LTR_TBL |
| 11 | LETTER_PRINTED_DT |
Date(10) | DATE | Date letter was printed |