SFA_LN_CNSL_TBL

(SQL Table)
 Index Back

Loan Counseling Information

Maintain student's loan counseling information.

  • Parent Record Of SFA_LN_CNSL_HIS SFA_LN_CNSL_HVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    4 SFA_LOAN_CODE Character(4) VARCHAR2(4) NOT NULL Loan Code

    Prompt Table: SFA_LN_CNSL_LVW

    5 SFA_LN_CNSL_TYPE Character(1) VARCHAR2(1) NOT NULL Counseling Type
    1=Entrance
    2=Exit
    6 SFA_LN_CNSL_REQ Character(1) VARCHAR2(1) NOT NULL Counseling Requirement
    A=Required Annually
    M=Required Once
    7 SFA_LN_CNSL_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    C=Completed
    I=Incomplete
    P=Pending

    Default Value: P

    8 SFA_LN_CNSL_CMP_DT Date(10) DATE Date Completed
    9 SFA_LN_CNSL_MSG Character(254) VARCHAR2(254) NOT NULL Comment