INSTITUTIONPrompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: AID_YEAR_TBL
LOAN_PROGRAMA=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
ECTRANSIDLN_FIELD_NUMBERLN_STGN_FLD_NBRPrompt Table: PSRECDEFN
LN_XFER_STG_TBL(SQL Table) |
Index Back |
|---|---|
Loan XREF Stgn Fld TableLoan Staging (EC) table Cross Reference |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 3 | LOAN_PROGRAM |
Character(1) | VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative D=Direct Lending F=FFELP H=Health Professions P=Perkins S=State U=University |
| 4 | ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 5 | LN_FIELD_NUMBER |
Number(3,0) | SMALLINT NOT NULL | Loan Field Nbr |
| 6 | LN_STGN_FLD_NBR |
Number(3,0) | SMALLINT NOT NULL | Loan Staging Fld Nbr |
| 7 | LN_DB_STAGE_REC | Character(15) | VARCHAR2(15) NOT NULL |
Loan Staging Record
Prompt Table: PSRECDEFN |
| 8 | LN_DB_STAGE_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Loan Staging Fld Name |