SSF_RUN_TPC_DTL

(SQL Table)
 Index Back

TPC Rollover Dtl - Run Cntrl

TPC Rollover Dtl - Run Cntrl

  • Parent record: SSF_RUN_TPCROLL

    • # 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: SSF_RUN_TPCROLL.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: SSF_RUN_TPCROLL.RUN_CNTL_ID

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: SSF_RUN_TPCROLL.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    4 TP_CONTRACT_FROM Character(25) VARCHAR2(25) NOT NULL Contract Num From

    Prompt Table: SSF_TPCNTRC_SRC

    5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    8 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    9 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List

    Prompt Table: CRSE_LST_HDR_SF
    Set Control Field: BUSINESS_UNIT

    10 SSF_TPCON_USERDEF1 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 1.
    11 SSF_TPCON_USERDEF2 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 2.
    12 SSF_TPCON_USERDEF3 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 3.
    13 SSF_TPCON_USERDEF4 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 4.
    14 SSF_TPCON_USERDEF5 Character(50) VARCHAR2(50) NOT NULL Third Party Contract User Defined Field 5.
    15 SSF_ERROR_WARN Character(1) VARCHAR2(1) NOT NULL Field to hold translate values for Message Types - Error/Warning/Message
    E=Error
    M=Message
    W=Warning