LN_XFER_ID_TBL

(SQL Table)
Index Back

Loan Transfer ID Table

Loan Origination Loan Transfer ID Table

  • Related Language Record: LNXFERIDTBLLNG
  • Parent Record Of LN_XFER_FLD_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.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_ECTRANS_VW

    4 LN_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Loan Action Type

    Prompt Table: LN_ACTNTYPE_TBL

    5 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
    I=Inbound
    O=Outbound

    Default Value: LN_ECTRANS_VW.ECTRANSINOUTSW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: LN_ECTRANS_VW.DESCR

    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LN_XFER_ID_TBL.DESCR

    8 LN_BATCH_ID Character(2) VARCHAR2(2) NOT NULL Loan Batch ID
    9 LN_BATCH_YR_INDC Character(1) VARCHAR2(1) NOT NULL Loan Batch Year Indicator
    10 LN_EDI_SRC_ENT_CD Character(8) VARCHAR2(8) NOT NULL FA EDI Source Entity Cd

    Prompt Table: LN_EDI_INTTP_VW

    11 LN_EDI_SRC_BU Character(5) VARCHAR2(5) NOT NULL FA EDI Source Business Unit

    Default Value: LN_EDI_INTTP_VW.LN_EDI_SRC_BU

    12 LN_EDI_DEST_ENT_CD Character(8) VARCHAR2(8) NOT NULL FA EDI Destination Entity Cd

    Prompt Table: LN_EXTENTCD_VW