CA_TICS_OPRMS

(SQL Table)
Index Back

Personalize CA MS Metrics

# 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 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_CA_NONVW

4 CA_BU_SOURCE Character(1) VARCHAR2(1) NOT NULL Determines source of the Business Unit CA - from user preference or specified value.
S=Specify
U=User Preferences

Default Value: U

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

Prompt Table: CA_TYPE_TBL
Set Control Field: SETCNTRLVALUE

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 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

Prompt Table: CA_REGION_CD_VW
Set Control Field: SETCNTRLVALUE

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

Prompt Table: CA_HDR_RQST_VW

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

Prompt Table: MEMBER_VW
Set Control Field: SETCNTRLVALUE

10 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW
Set Control Field: SETCNTRLVALUE

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL
Set Control Field: SETCNTRLVALUE

12 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

Prompt Table: SUBCUST_Q1_TBL
Set Control Field: SETCNTRLVALUE

13 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

Prompt Table: SUBCUST_Q2_TBL
Set Control Field: SETCNTRLVALUE

14 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: PC_CAL_BP_VW

15 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods
16 CA_PAGELET_FORMAT Character(1) VARCHAR2(1) NOT NULL Pagelet Format
1=Tabular
2=Chart

Default Value: 1

17 MY_CONTRACTS Character(1) VARCHAR2(1) NOT NULL Contracts

Y/N Table Edit

18 MS_SORT_BY Character(1) VARCHAR2(1) NOT NULL Indiation for sorting the Milestone Metric by either MILESTONE_ID or MILESTONE_STATUS
1=Milestone Status
2=Milestone ID

Default Value: 1