CA_LMT_PROC_OPT

(SQL Table)
Index Back

Limits Options 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).

Default Value: CA_LMT_PROC_RC.OPRID

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

Default Value: CA_LMT_PROC_RC.RUN_CNTL_ID

3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

Default Value: CA_LMT_PROC_RC.REQUEST_ID

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

Prompt Table: SP_BU_CA_NONVW

5 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

Prompt Table: CA_TYPE_VW

6 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
7 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

8 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTR_HDR

9 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

Prompt Table: CA_DETAIL

10 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

Prompt Table: MEMBER_VW