SCC_AFL_HIST_VW

(SQL View)
 Index Back

Affiliation History view

Affiliation History view

SELECT DISTINCT EMPLID ,INSTITUTION ,SCC_AFL_CODE ,START_DT ,SCC_AFL_SPONS_DEPT ,SCC_AFL_PLCD_MTD ,SCC_AFL_RLCD_MTD ,SCC_AFL_STATUS ,SCC_AFL_STS_DESCR ,SCC_AFL_RANK ,END_DT ,LASTUPDOPRID ,LASTUPDDTTM ,0 FROM PS_SCC_AFL_PERSON

  • Related Language Record: SCC_AFLHSTVW_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code
    4 START_DT Date(10) DATE Start Date
    5 SCC_AFL_SPONS_DEPT Character(10) VARCHAR2(10) NOT NULL Affiliation Code's Sponsoring Department

    Prompt Table: SCC_DEPT_TBL_VW

    6 SCC_AFL_PLCD_MTD Character(1) VARCHAR2(1) NOT NULL Placed Method for Affiliations
    B=Batch
    E=Event
    M=Manual
    S=System
    7 SCC_AFL_RLCD_MTD Character(1) VARCHAR2(1) NOT NULL Released Method for Affiliations
    B=Batch
    E=Event
    M=Manual
    S=System
    8 SCC_AFL_STATUS Character(3) VARCHAR2(3) NOT NULL Affiliation Status
    ACT=Active
    ERR=Created In Error
    INA=Inactive
    9 SCC_AFL_STS_DESCR Character(30) VARCHAR2(30) NOT NULL Affiliation Status Description

    Prompt Table: SCC_AFL_STS_DES

    10 SCC_AFL_RANK Character(5) VARCHAR2(5) NOT NULL Affiliation Ranking per institution
    11 END_DT Date(10) DATE end date
    12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    14 SCC_AFL_HIERAR_LVL Number(3,0) SMALLINT NOT NULL Affiliations Hierarchy Level