SSF_RUNCTL_CAN

(SQL Table)
 Index Back

Run Control for SF CAN

  • Parent Record Of SSF_RUNCTL_CANC SSF_RUNCTL_CANE SSF_RUNCTL_CANG SSF_RUNCTL_CANL SSF_RUNCTL_CANP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    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 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    5 SSF_FROM_CENSUS_DT Date(10) DATE NOT NULL From Census Date
    6 SSF_TO_CENSUS_DT Date(10) DATE NOT NULL To Census Date
    7 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

    Prompt Table: ADDR_USAGE_TBL

    8 SSF_REPRINT Character(1) VARCHAR2(1) NOT NULL Reprint

    Y/N Table Edit

    Default Value: Y

    9 ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Error or Warning
    E=Error
    W=Warning
    10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.