SFA_SLC_SSACHDR

(SQL Table)
Index Back

SLC SSAC Header

SLC Student Support Attendance Confirmation Staging Table

  • Parent Record Of SFA_SLC_SSACDTL
  • # 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_LOC_CD Character(2) VARCHAR2(2) NOT NULL Location Code
    4 SFA_SLC_FILE_SEQ Number(5,0) INTEGER NOT NULL Sequence Number
    5 SFA_SLC_REC_TYPE Character(2) VARCHAR2(2) NOT NULL Record Type
    6 SFA_SLC_FILE_TYPE Character(2) VARCHAR2(2) NOT NULL File Type
    7 SFA_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path
    8 SFA_FILE_NAME Character(128) VARCHAR2(128) NOT NULL File Name
    9 SFA_SLC_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Processing Status
    K=Skip
    P=Processed
    S=Suspended
    U=Unprocessed

    Default Value: U

    10 SFA_SLC_PROC_DTTM DateTime(26) TIMESTAMP Processed Date/Time