CA_DETAIL_PRO_H

(SQL Table)
Index Back

Contr line project details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
5 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Default Value: CA_DETAIL.BUSINESS_UNIT_PC

6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDITTABLE2

7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDITTABLE3

8 BILLED_TO_DATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed To Date
9 ACTIVITY_FLAG Character(3) VARCHAR2(3) NOT NULL Use all activities
ALL=All Activities
ONE=One Activity

Default Value: ONE

10 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RES_TYPE
Set Control Field: BUSINESS_UNIT_PC

11 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

12 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

13 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

Y/N Table Edit

Default Value: N

14 TARGET_EXCESS Character(1) VARCHAR2(1) NOT NULL Target Excess field def for display on CA_DETAIL_PROJ.
N=No
Y=Yes