SFA_CRC_FIN_DAT

(SQL Table)
Index Back

Financial Data

Contains Student Financial Data

  • Parent record: SFA_CRC_ATTSCHL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
    2 SFA_CR_RECIP_ID Character(12) VARCHAR2(12) NOT NULL CRC Recipient ID
    3 SFA_CR_ATT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Attended School ID
    4 SFA_CR_STUDENT_ID Character(20) VARCHAR2(20) NOT NULL School Assigned Student Id
    5 SFA_CR_GROSS_SALRY Character(12) VARCHAR2(12) NOT NULL Gross Annual Salary
    6 SFA_CR_OTHER_INC Character(12) VARCHAR2(12) NOT NULL Other Income
    7 SFA_CR_OTH_INC_SRC Character(12) VARCHAR2(12) NOT NULL Other Income Source
    8 SFA_CR_HOUSE_PMT Character(12) VARCHAR2(12) NOT NULL House Monthly Payment
    9 SFA_CR_CRDCARD_PMT Character(12) VARCHAR2(12) NOT NULL Credit Card Monthly Payment
    10 SFA_CR_AUTO_PMT Character(12) VARCHAR2(12) NOT NULL Automobile Monthly Payment
    11 SFA_CR_ED_LOAN_PMT Character(12) VARCHAR2(12) NOT NULL Education Loan Monthly Payment
    12 SFA_CR_OTHER_PMT Character(12) VARCHAR2(12) NOT NULL Other Monthly Payment
    13 SFA_CR_TOT_STU_LN Character(12) VARCHAR2(12) NOT NULL Total Student Loan Debt Amount
    14 SFA_CR_STAF_DEBT Character(12) VARCHAR2(12) NOT NULL Stafford Loan Debt Amount
    15 SFA_CR_SLS_DEBT Character(12) VARCHAR2(12) NOT NULL SLS Debt Amount
    16 SFA_CR_HEAL_DEBT Character(12) VARCHAR2(12) NOT NULL HEAL Debt Amount
    17 SFA_CR_PERK_DEBT Character(12) VARCHAR2(12) NOT NULL Perkins Debt Amount
    18 SFA_CR_OTHER_DEBT Character(12) VARCHAR2(12) NOT NULL Other Debt Amount
    19 SFA_CR_OTHR_LN_CUR Character(12) VARCHAR2(12) NOT NULL Other Ln This Period Debt Amt
    20 SFA_CR_CRD_AUTH Character(5) VARCHAR2(5) NOT NULL Credit Authorization Indicator
    21 SFA_CR_CRD_DIF_NAM Character(5) VARCHAR2(5) NOT NULL Credit Under Different Name
    22 SFA_CR_HOME_OWNER Character(5) VARCHAR2(5) NOT NULL Home Owner Indicator
    23 SFA_CR_YR_AT_ADDR Character(2) VARCHAR2(2) NOT NULL Year At Address
    24 SFA_CR_STAFSLS_DBT Character(12) VARCHAR2(12) NOT NULL Total Stafford/SLS Debt
    25 SFA_CR_PLUS_DEBT Character(12) VARCHAR2(12) NOT NULL PLUS Debt Amount
    26 SFA_CR_RESPONSE_CD Character(15) VARCHAR2(15) NOT NULL Response Code