EMPLIDPrompt Table: PERSON
EMPL_RCDSTART_DATEDefault Value: Y
GPGB_EE_STLOAN(SQL Table) |
Index Back |
|---|---|
Student LoansCaptures Student Loan details |
| # | 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 | START_DATE |
Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | GPGB_STDNT_LN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Student Loan Indicator
Default Value: Y |
| 6 | GPGB_STDNT_LN_REF | Character(20) | VARCHAR2(20) NOT NULL | Student Loan Reference |