LN_XFER_FLD_TBL(SQL Table) |
Index Back |
---|---|
Loan Cross Reference Fld TableLoan Origination Loan Cross Reference Fld Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: FED_AID_YR_TBL |
2 | 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 |
3 | 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)
Prompt Table: LN_XFER_ID_TBL |
4 | LN_FIELD_NUMBER | Number(3,0) | SMALLINT NOT NULL | Loan Field Nbr |
5 | LN_REC_FIELD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Loan Trans ID Field Name |
6 | LN_FIELD_START_POS | Number(4,0) | SMALLINT NOT NULL | Trans Field Start Position |
7 | LN_FIELD_LENGTH | Number(2,0) | SMALLINT NOT NULL | Trans Field Length |
8 | LN_FIELD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Loan Field Type
A=Alpha AN=Alphanumeric D=Date DT=Date/Time N=Number SN=Signed Number |
9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: LN_TBL_VW |