EMPLIDPrompt Table: PERSON
EMPL_RCDGPGB_SL_PLAN_TYPE1=Plan Type 1
2=Plan Type 2
3=Post Graduate Loan
4=Plan Type 4
Default Value: 1
START_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 Record |
| 3 | GPGB_SL_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
This field determines the Plan type for Student Loan Plans
1=Plan Type 1 2=Plan Type 2 3=Post Graduate Loan 4=Plan Type 4 Default Value: 1 |
| 4 | START_DATE |
Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | GPGB_STDNT_LN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Student Loan Indicator
Default Value: Y |
| 7 | GPGB_STDNT_LN_REF | Character(20) | VARCHAR2(20) NOT NULL | Student Loan Reference |