SSR_RNCTL_ARTS

(SQL Table)
 Index Back

Run Cntl for ARTS

  • Parent Record Of SSR_RNCTL2_ARTS

    • # 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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
    5 SSR_CMNT_CATEGORY1 Character(6) VARCHAR2(6) NOT NULL Comment Category 1

    Prompt Table: CMNT_CATG_TBL

    6 SSR_CMNT_CATEGORY2 Character(6) VARCHAR2(6) NOT NULL Comment Category 2

    Prompt Table: CMNT_CATG_TBL

    7 SSR_CMNT_CATEGORY3 Character(6) VARCHAR2(6) NOT NULL Comment Category 3

    Prompt Table: CMNT_CATG_TBL

    8 SSR_CMNT_CATEGORY4 Character(6) VARCHAR2(6) NOT NULL Comment Category 4

    Prompt Table: CMNT_CATG_TBL

    9 SSR_CMNT_CATEGORY5 Character(6) VARCHAR2(6) NOT NULL Comment Category 5

    Prompt Table: CMNT_CATG_TBL

    10 SSR_COMM_CATEGORY1 Character(6) VARCHAR2(6) NOT NULL Communication Category 1

    Prompt Table: COMM_CATG_TBL

    11 SSR_COMM_CATEGORY2 Character(6) VARCHAR2(6) NOT NULL Communication Category 2

    Prompt Table: COMM_CATG_TBL

    12 SSR_COMM_CATEGORY3 Character(6) VARCHAR2(6) NOT NULL Communication Category 3

    Prompt Table: COMM_CATG_TBL

    13 SSR_COMM_CATEGORY4 Character(6) VARCHAR2(6) NOT NULL Communication Category 4

    Prompt Table: COMM_CATG_TBL

    14 SSR_COMM_CATEGORY5 Character(6) VARCHAR2(6) NOT NULL Communication Category 5

    Prompt Table: COMM_CATG_TBL

    15 SSR_FILE_PATH_OUT Character(127) VARCHAR2(127) NOT NULL Output Filepath
    16 SSR_HONORS_CAT1 Character(6) VARCHAR2(6) NOT NULL Honours Category 1 (Lvl I)

    Prompt Table: HONOR_AWARD_TBL

    17 SSR_HONORS_CAT2 Character(6) VARCHAR2(6) NOT NULL Honours Category 2 (Lvl IIA)

    Prompt Table: HONOR_AWARD_TBL

    18 SSR_HONORS_CAT3 Character(6) VARCHAR2(6) NOT NULL Honours Category 3 (Lvl II)

    Prompt Table: HONOR_AWARD_TBL

    19 SSR_HONORS_CAT4 Character(6) VARCHAR2(6) NOT NULL Honours Category 4 (Lvl IIB)

    Prompt Table: HONOR_AWARD_TBL

    20 SSR_HONORS_CAT5 Character(6) VARCHAR2(6) NOT NULL Honours Category 5 (Lvl III)

    Prompt Table: HONOR_AWARD_TBL

    21 SSR_SRVC_IND_FEES Character(3) VARCHAR2(3) NOT NULL Service Indicator - Fees

    Prompt Table: SRVC_IND_CD_TBL

    22 SSR_SRVC_IND_OTHER Character(3) VARCHAR2(3) NOT NULL Service Indicator - Other

    Prompt Table: SRVC_IND_CD_TBL

    23 SSR_SRVIND_RSN_FEE Character(5) VARCHAR2(5) NOT NULL Servc Indicator Reason - Fees

    Prompt Table: SSR_SRVRSNARTVW

    24 SSR_SRVIND_RSN_OTR Character(5) VARCHAR2(5) NOT NULL Servc Indicator Reason - Other

    Prompt Table: SSR_SRVRSNARTV2