COUNTRYPrompt Table: GP_CNTRY_OP_VW
LVDN_PRGM_IDPrompt Table: GP_ABS_LVDN_VW
EMPLIDPrompt Table: GP_EMP_SEC_VW
EMPL_RCDPrompt Table: EMPLMT_SRCH_GBL
GP_ABS_LVDN_RCP(SQL Table) |
Index Back |
|---|---|
Leave Donation Prgm RecipientsLeave Donation Progam Recipients |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_CNTRY_OP_VW |
| 2 | LVDN_PRGM_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Leave Program
Prompt Table: GP_ABS_LVDN_VW |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GP_EMP_SEC_VW |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLMT_SRCH_GBL |
| 5 | ELIG_BGN_DT | Date(10) | DATE NOT NULL | Leave Donation Recipient Eligibility Begin Date |
| 6 | ELIG_END_DT | Date(10) | DATE | Leave Donation Recipient Eligibility End Date |
| 7 | COMMENTS | Long Character | CLOB | Comment |