EMPLIDPrompt Table: PERSON
EMPL_RCDGPDE_AB_EXPECT_DT1GPDE_AL_SEQNUMPrompt Table: STANDRD_LTR_TBL
GPDE_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 | GPDE_AB_EXPECT_DT1 |
Date(10) | DATE | Expected Date of Birth |
| 4 | GPDE_AL_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | LETTER_CD | Character(3) | VARCHAR2(3) NOT NULL |
Letter code
Prompt Table: STANDRD_LTR_TBL |
| 6 | LETTER_PRINTED_DT | Date(10) | DATE | Date letter was printed |