PC_ED_TRANS_RS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
4	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
5	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
6	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
7	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
8	RES_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Resource Type Description
9	TRANS_DT	Date(10)	DATE	Transaction Date Default Value: %date
10	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: %date
11	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 Default Value: N
12	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 Default Value: I
13	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
15	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
16	BUDGET_PERIOD	Character(8)	VARCHAR2(8) NOT NULL	Budget Period
17	PROJ_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Project ID Description
18	ACTIVITY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Activity Description
19	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
20	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
21	PROJECT_USER1	Character(10)	VARCHAR2(10) NOT NULL	Project User 1
22	PROJECT_USER2	Character(10)	VARCHAR2(10) NOT NULL	Project User 2
23	PROJECT_USER3	Character(10)	VARCHAR2(10) NOT NULL	Project User 3
24	PROJECT_USER4	Character(10)	VARCHAR2(10) NOT NULL	Project User 4
25	PROJECT_USER5	Character(10)	VARCHAR2(10) NOT NULL	Project User 5
26	ACTIVITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status
27	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete
28	PC_MILESTONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Milestone Activity N=No Y=Yes
29	ACTIVITY_USER1	Character(10)	VARCHAR2(10) NOT NULL	User 1
30	ACTIVITY_USER2	Character(10)	VARCHAR2(10) NOT NULL	User 2
31	ACTIVITY_USER3	Character(10)	VARCHAR2(10) NOT NULL	User 3
32	ACTIVITY_USER4	Character(10)	VARCHAR2(10) NOT NULL	User 4
33	ACTIVITY_USER5	Character(10)	VARCHAR2(10) NOT NULL	User 5
34	SET_OVERRIDE	Character(5)	VARCHAR2(5) NOT NULL	FS_08 SetID
35	AN_GRP_ACTV_BUD	Character(5)	VARCHAR2(5) NOT NULL	Budget Analysis Group
36	AN_GRP_TOT_COSTS	Character(5)	VARCHAR2(5) NOT NULL	Cost Analysis Group
37	PC_REV_BUD_AN_GRP	Character(5)	VARCHAR2(5) NOT NULL	Revenue budget analysis group
38	AN_GRP_TOT_REV	Character(5)	VARCHAR2(5) NOT NULL	Cost Analysis Group
39	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
40	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
41	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
42	BUDGET_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Projects Budget Amount
43	ACTUAL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Invoice Amount
44	BUD_REV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Budget or Revenue Amount
45	PC_REVENUE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue
46	PC_ACTUAL_HRS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Actual Hours
47	PC_BUDGET_HRS	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Budget Hours
48	BILLED_TO_DATE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billed To Date