CA_TICS_OPRSTAT

(SQL Table)
Index Back

Personalize CA Status Metrics

Set personalization fields for the Analytics Status Metric

# 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 MY_CONTRACTS Character(1) VARCHAR2(1) NOT NULL Contracts

Y/N Table Edit

6 SHOW_PENDING Character(1) VARCHAR2(1) NOT NULL Show Pending

Y/N Table Edit

Default Value: N

7 SHOW_ACTIVE Character(1) VARCHAR2(1) NOT NULL Show Active

Y/N Table Edit

Default Value: Y

8 SHOW_CLOSED Character(1) VARCHAR2(1) NOT NULL Show Closed

Y/N Table Edit

Default Value: N

9 CA_PAGELET_FORMAT Character(1) VARCHAR2(1) NOT NULL Pagelet Format
1=Tabular
2=Chart

Default Value: 1

10 BY_CNT_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Sort by Count or Amount
A=By Amount
C=By Count

Default Value: C

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

Prompt Table: CA_TYPE_TBL
Set Control Field: SETCNTRLVALUE

12 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
13 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

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

Prompt Table: CA_HDR_RQST_VW

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

Prompt Table: MEMBER_VW
Set Control Field: SETCNTRLVALUE

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

Prompt Table: CUST_SLD_VW
Set Control Field: SETCNTRLVALUE

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

Prompt Table: CURRENCY_CD_TBL
Set Control Field: SETCNTRLVALUE

18 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

19 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

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

Prompt Table: PC_CAL_BP_VW

21 DESCR Character(30) VARCHAR2(30) NOT NULL Description

Prompt Table: PC_CAL_BP_VW

22 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods