SCC_AFL_PRG_RST

(SQL Table)
 Index Back

Pop select Results record

Pop select results record for Select/Delete Affiliation

  • Parent record: SCC_AFL_PRG_RUN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution

    Prompt Table: INSTITUTION_TBL

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    5 SCC_AFL_CODE Character(10) VARCHAR2(10) NOT NULL Affiliations Code

    Prompt Table: SCC_AFL_LVS_VW

    6 START_DT Date(10) DATE NOT NULL Start Date
    7 SCC_AFL_SPONS_DEPT Character(10) VARCHAR2(10) NOT NULL Affiliation Code's Sponsoring Department

    Prompt Table: SCC_DEPT_TBL_VW

    8 END_DT Date(10) DATE end date
    9 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.
    10 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.

    Default Value: %datetime

    11 SCC_AFL_PLCD_MTD Character(1) VARCHAR2(1) NOT NULL Placed Method for Affiliations
    B=Batch
    E=Event
    M=Manual
    S=System

    Default Value: E

    12 SCC_AFL_RLCD_MTD Character(1) VARCHAR2(1) NOT NULL Released Method for Affiliations
    B=Batch
    E=Event
    M=Manual
    S=System
    13 SCC_AFL_STATUS Character(3) VARCHAR2(3) NOT NULL Affiliation Status
    ACT=Active
    ERR=Created In Error
    INA=Inactive

    Default Value: ACT

    14 SCC_AFL_STS_DESCR Character(30) VARCHAR2(30) NOT NULL Affiliation Status Description

    Prompt Table: SCC_AFL_STS_DES

    15 SCC_AFL_RANK Character(5) VARCHAR2(5) NOT NULL Affiliation Ranking per institution