SFA_SLC_CD_INST

(SQL Table)
Index Back

SLC HEI Course DB Institution

SLC HEI Course Database Insitution Data

  • Parent record: SFA_SLC_CD_IHDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_SLC_ACAD_YR Character(4) VARCHAR2(4) NOT NULL SLC Acad Year

    Prompt Table: SFA_SLC_ACYRVW2

    2 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code

    Prompt Table: SFA_SLC_HEI_VW2

    3 SFA_SLC_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    4 SFA_SLC_HEI_NAME Character(50) VARCHAR2(50) NOT NULL HEI Name
    5 SFA_SLC_HEI_S_NAME Character(45) VARCHAR2(45) NOT NULL HEI Shortname
    6 SFA_SLC_HEI_CNTRY Character(16) VARCHAR2(16) NOT NULL Country Name
    7 SFA_SLC_UCAS_COLCD Character(3) VARCHAR2(3) NOT NULL UCAS College Code
    8 SFA_SLC_RESULT_NBR Signed Number(7,0) DECIMAL(6) NOT NULL Result Number
    9 SFA_SLC_RESULT_MSG Character(100) VARCHAR2(100) NOT NULL Result Message
    10 SFA_SLC_LAST_DTTM Character(25) VARCHAR2(25) NOT NULL Last Updated DateTime
    11 SFA_SLC_CD_STAT Character(1) VARCHAR2(1) NOT NULL Course Database Status
    1=Data Received from SLC
    2=Data successfully sent to SLC
    3=Error sending to SLC
    4=Data rejected by SLC
    5=Data will be sent to SLC
    6=Obsolete Data

    Default Value: 5

    12 SFA_SLC_LIVE_DTTM Character(25) VARCHAR2(25) NOT NULL Live Date