SFA_SLC_CD_LOC

(SQL Table)
Index Back

SLC HEI Course DB Location

SLC HEI Course Database Location 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_CAMPUS_CD Character(1) VARCHAR2(1) NOT NULL Campus Code
    4 SFA_SLC_FRANCHISE Character(1) VARCHAR2(1) NOT NULL Franchise Location

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

    6 SFA_SLC_PRIMARY Character(1) VARCHAR2(1) NOT NULL Primary Location

    Y/N Table Edit

    Default Value: N

    7 SFA_SLC_LOC_NAME Character(32) VARCHAR2(32) NOT NULL Location Name
    8 SFA_SLC_LOC_ADDR1 Character(60) VARCHAR2(60) NOT NULL Address Line 1
    9 SFA_SLC_LOC_ADDR2 Character(60) VARCHAR2(60) NOT NULL Address Line 2
    10 SFA_SLC_LOC_ADDR3 Character(60) VARCHAR2(60) NOT NULL Address Line 3
    11 SFA_SLC_LOC_ADDR4 Character(60) VARCHAR2(60) NOT NULL Address Line 4
    12 SFA_SLC_LOC_ADDR5 Character(60) VARCHAR2(60) NOT NULL Address Line 5
    13 SFA_SLC_POST_CD Character(8) VARCHAR2(8) NOT NULL Post Code
    14 SFA_SLC_LOC_PHONE Character(20) VARCHAR2(20) NOT NULL Phone Number
    15 SFA_SLC_LOC_FAX Character(20) VARCHAR2(20) NOT NULL Fax Number
    16 SFA_SLC_LOC_EMAIL Character(60) VARCHAR2(60) NOT NULL Email Address
    17 SFA_SLC_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

    Y/N Table Edit

    Default Value: Y

    18 SFA_SLC_RESULT_NBR Signed Number(7,0) DECIMAL(6) NOT NULL Result Number
    19 SFA_SLC_RESULT_MSG Character(100) VARCHAR2(100) NOT NULL Result Message
    20 SFA_SLC_LAST_DTTM Character(25) VARCHAR2(25) NOT NULL Last Updated DateTime
    21 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

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