RUN_CNTL_CONFO

(SQL Table)
Index Back

Confo Register Run Control

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

Prompt Table: OPR_DEF_TBL_FS

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_TRD_NONVW

4 DEAL_CONF_STATUS Character(2) VARCHAR2(2) NOT NULL Reflects the confirmation status of a given deal transaction at any particular point in time.
01=Pending
02=Confirmed
03=Invalid

Default Value: 01

5 FROM_DT Date(10) DATE From Date

Default Value: %date

6 TO_DT Date(10) DATE To Date

Default Value: %date