LOAN_RELATN_ID

(SQL Table)
Index Back

Loan Relation ID

Record containing information on persons "related" to a loan such as Co-Makers and References.

  • Parent record: LOAN_ORIGNATN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    4 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd

    Prompt Table: LN_TYPE_TBL

    5 LN_RELATION_SEQ Number(3,0) SMALLINT NOT NULL Current Address
    6 LOAN_RELATION_TYPE Character(1) VARCHAR2(1) NOT NULL Loan Relation Type
    M=Co-Maker
    R=Reference
    S=Co-Signer
    7 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr

    Prompt Table: SFA_CRC_REL_VW

    8 LN_APPL_NUMBER Number(3,0) SMALLINT NOT NULL Loan Application Number
    9 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num

    Default Value: LOAN_ORIGNATN.LN_APPL_SEQ

    10 SIGNATURE_INDCTR Character(1) VARCHAR2(1) NOT NULL Signature Indicator

    Y/N Table Edit

    11 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
    12 EMPL_ADDRESS1 Character(35) VARCHAR2(35) NOT NULL Employer Address Line 1
    13 EMPL_ADDRESS2 Character(35) VARCHAR2(35) NOT NULL Employer Address Line 2
    14 EMPL_CITY Character(30) VARCHAR2(30) NOT NULL Employer City
    15 EMPL_STATE Character(6) VARCHAR2(6) NOT NULL Employer State
    16 EMPL_POSTAL Character(12) VARCHAR2(12) NOT NULL Postal Code
    17 EMPL_PHONE Character(12) VARCHAR2(12) NOT NULL EmployerTelephone
    18 FOREIGN_POSTAL Character(14) VARCHAR2(14) NOT NULL Foreign Postal Code
    19 HOUSING_PAYMENT Number(5,0) INTEGER NOT NULL Monthly Housing Payment
    20 OWN_RENT_IND Character(1) VARCHAR2(1) NOT NULL Owner/Renter Indicator
    O=Own
    R=Rent
    21 PREV_ADDRESS1 Character(35) VARCHAR2(35) NOT NULL Previous Address Line 1
    22 PREV_ADDRESS2 Character(35) VARCHAR2(35) NOT NULL Previous Address Line 2
    23 PREV_CITY Character(30) VARCHAR2(30) NOT NULL Previous City
    24 PREV_STATE Character(6) VARCHAR2(6) NOT NULL Previous State
    25 PREV_POSTAL Character(12) VARCHAR2(12) NOT NULL Postal Code
    26 SELF_EMPLOYED Character(1) VARCHAR2(1) NOT NULL Self-Employed

    Y/N Table Edit

    Default Value: N

    27 CURR_JOB_POSITION Character(26) VARCHAR2(26) NOT NULL Current Job Position
    28 YRS_AT_CURR_JOB Number(2,0) SMALLINT NOT NULL Years at Current Job
    29 OTHR_INCOME_SRC Character(15) VARCHAR2(15) NOT NULL Other Income Source
    30 PREV_EMPLOYER Character(30) VARCHAR2(30) NOT NULL Previous Employer
    31 PREV_JOB_POSITION Character(30) VARCHAR2(30) NOT NULL Previous Job Position
    32 PREV_EMPL_PHONE Character(12) VARCHAR2(12) NOT NULL Previous EmployerTelephone
    33 ANNUAL_SALARY Number(19,3) DECIMAL(18,3) NOT NULL Pulblic Sector Financials Budget Work Field
    34 OTHR_ANNUAL_INC Number(7,0) INTEGER NOT NULL Other Annual Income
    35 YRS_AT_CURR_ADDR Number(2,0) SMALLINT NOT NULL Years at Current Address
    36 SFA_CR_MTH_AT_EMPL Character(2) VARCHAR2(2) NOT NULL Months At Current Employer
    37 SFA_CR_MTH_PRV_EMP Character(2) VARCHAR2(2) NOT NULL Months at Previous Employer