SFA_LN_CNSL_HVW

(SQL View)
 Index Back

Loan Counseling Information

Maintain student's loan counseling information.

SELECT INSTITUTION ,EMPLID ,AID_YEAR ,SFA_LOAN_CODE ,SFA_LN_CNSL_TYPE ,DL_SEQ_NBR ,SFA_LN_CNSL_REQ ,SFA_LN_CNSL_STATUS ,SFA_LN_CNSL_CMP_DT ,SFA_LN_CNSL_MSG FROM PS_SFA_LN_CNSL_HIS

  • Parent record: SFA_LN_CNSL_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic 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

    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 DL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL Sequence Number
    7 SFA_LN_CNSL_REQ Character(1) VARCHAR2(1) NOT NULL Counseling Requirement
    A=Required Annually
    M=Required Once
    8 SFA_LN_CNSL_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    C=Completed
    I=Incomplete
    P=Pending
    9 SFA_LN_CNSL_CMP_DT Date(10) DATE Date Completed
    10 SFA_LN_CNSL_MSG Character(254) VARCHAR2(254) NOT NULL Comment