CA_FEE_PRCS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	CA_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Contract Plan ID
4	CA_FEE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Determine if it is a Bill Plan or a Rev.Plan 01=Billing Process 02=Revenue Process 03=Billing Worksheet 04=Revenue Worksheet
5	SEPARATE_BIL_REV	Character(1)	VARCHAR2(1) NOT NULL	Flag used by Governement Contracts to separate Billing and Revenue transactions
6	ANALYSIS_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Analysis Group
7	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
8	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
9	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
10	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	CA_FEE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Cost Plus Fee Type 01=None 02=Fixed Fee 03=Award Fee 04=Incentive Fee 05=Other Fee
13	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
14	TABLE_NAME_FROM	Character(30)	VARCHAR2(30) NOT NULL	Table Name From
15	TABLE_NAME2	Character(30)	VARCHAR2(30) NOT NULL	TABLE_NAME2
16	RECNAME_1	Character(15)	VARCHAR2(15) NOT NULL	Record 1 Name
17	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
18	RECNAME_3	Character(15)	VARCHAR2(15) NOT NULL	Rename
19	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
20	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
21	FIELDNAME2	Character(18)	VARCHAR2(18) NOT NULL	Fieldname 2
22	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition)
23	SQLID2	Character(30)	VARCHAR2(30) NOT NULL	SQL OBJECT WORK FIELD
24	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
25	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
26	LAST_RESOURCE_ID	Number(20,0)	DECIMAL(20) NOT NULL	Last Transaction ID
27	EVENT_OCCURRENCE	Number(3,0)	SMALLINT NOT NULL	Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
28	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
29	CA_FEE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cost Plus Fee Status for Governement Contracts 1=Fee Generated 2=Bil Actual Fee 3=Bil Additional Award Fee 4=Rev Actual Fee 5=Rev Additional Award Fee
30	CA_FEE_AWSCHED_LNK	Character(1)	VARCHAR2(1) NOT NULL	Field used as hyperlink to go to the Award Schedule page.
31	BI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Distribution Status D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet
32	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
33	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
34	CA_AUX1_WRK	Character(3)	VARCHAR2(3) NOT NULL	Auxiliar Field 1
35	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
36	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
37	CURR_TRANS_DATE	Character(3)	VARCHAR2(3) NOT NULL	Date Type ACT=Accounting Date TRN=Transaction Date