LN_XFER_FLD_TBL

(SQL Table)
Index Back

Loan Cross Reference Fld Table

Loan Origination Loan Cross Reference Fld Table

  • Parent record: LN_XFER_ID_TBL
  • # 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