SCC_AFL_PRG_RUN

(SQL Table)
 Index Back

Purge/Del Run Control record

Purge/Del Run Control record

  • Parent Record Of SCC_AFL_DLT_AET SCC_AFL_PRGRCNT SCC_AFL_PRG_RST SCC_AFL_PRG_TMP SCC_AFL_PRG_WRK

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

    Prompt Table: INSTITUTION_TBL

    4 SCC_AFL_PROCESS_BY Character(1) VARCHAR2(1) NOT NULL Affiliation Process By
    P=Population Selection
    S=Person ID
    5 SCC_AFL_AFL_SEL Character(1) VARCHAR2(1) NOT NULL Affiliation Process By
    A=All Codes
    O=One Or More Codes
    6 SCC_AFL_STATUS Character(3) VARCHAR2(3) NOT NULL Affiliation Status
    ACT=Active
    ERR=Created In Error
    INA=Inactive
    7 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    8 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    9 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    10 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    11 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    13 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
    14 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: SCC_AFL_PRMPT

    15 SCC_AFL_VIEW_PRG Character(1) VARCHAR2(1) NOT NULL View Purge Results