SFA_SLC_ACR_HDR

(SQL Table)
Index Back

ACR/TFPR Header

SLC Attendance Confirmation Report/Tuition Fee Position Report Header Staging Table

  • Parent Record Of SFA_SLC_ACR_DTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
    2 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year
    3 SFA_SLC_ISSUE_DT Date(10) DATE NOT NULL Issue Date
    4 SFA_SLC_LIAB_PRD Character(1) VARCHAR2(1) NOT NULL Liability Period
    1=1
    2=2
    3=3

    Default Value: 1

    5 SFA_SLC_HEI_NAME Character(50) VARCHAR2(50) NOT NULL HEI Name
    6 SFA_SLC_REC_COUNT Number(6,0) INTEGER NOT NULL Record Count
    7 SFA_SLC_TOT_LOAN Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Tuition Fee Loan Payable
    8 SFA_SLC_TOT_GRANT Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Tuition Grant Payable
    9 SFA_SLC_TOT_STDNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Total Tuition Fee Student Pays
    10 SFA_FILE_NAME Character(128) VARCHAR2(128) NOT NULL File Name
    11 SFA_SLC_TFPR_IND Character(1) VARCHAR2(1) NOT NULL TFPR Indicator

    Y/N Table Edit

    12 SFA_SLC_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Processing Status
    K=Skip
    P=Processed
    S=Suspended
    U=Unprocessed

    Default Value: U

    13 SFA_SLC_PROC_DTTM DateTime(26) TIMESTAMP Processed Date/Time
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    15 SFA_SLC_FILE_TYPE1 Character(3) VARCHAR2(3) NOT NULL File Type
    ACR=Attendance Confirmation Reqst
    EXT=Extended SISF
    SCA=Short Course Attendance
    SIS=Student Information Service

    Default Value: ACR