PGM_CHC_REQ_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDITTABLE
3	CHANGE_REQ_ID	Character(15)	VARCHAR2(15) NOT NULL	Change Request ID Default Value: NEXT
4	CHANGE_REQ_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Change Request Type B=Budget E=ETC P=Project
5	CROSS_PROJ_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cross Project Flag is used to indicate if a change request is a normal project change request or a cross project change request N=No Y=Yes Default Value: N
6	REQUESTED_BY	Character(11)	VARCHAR2(11) NOT NULL	Requested By Prompt Table: PC_TEAM_PROM_VW
7	APPROVED_BY	Character(11)	VARCHAR2(11) NOT NULL	APPROVED_BY Prompt Table: PC_CUR_PROJ_MGR Set Control Field: PROJECT_MANAGER
8	CREATION_DT	Date(10)	DATE NOT NULL	Creation Date Default Value: %Date
9	REQ_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=High 2=Medium 3=Low Default Value: 2
10	CHANGE_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Approved D=Declined P=Pending R=Returned S=Submitted Default Value: P
11	SUBMIT_DT	Date(10)	DATE	Date Submitted
12	ASSIGNED_TO_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Assigned to Employee ID Prompt Table: PERSONAL_DATA
13	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
14	ESTIMATED_DAYS	Number(6,2)	DECIMAL(5,2) NOT NULL	Estimated Days to complete the Change Request
15	APPROVER_ACTN_DT	Date(10)	DATE	The Date on which the approver takes necessary action
16	ROOT_CAUSE	Character(30)	VARCHAR2(30) NOT NULL	ROOT CAUSE
17	ROOT_CAUSE_AREA	Character(5)	VARCHAR2(5) NOT NULL	ROOT_CAUSE_AREA Prompt Table: PGM_ACT_RCA_SET
18	RISK_FACTOR	Number(2,0)	SMALLINT NOT NULL	Risk Factor for Change Request
19	PRJ_CHNG_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description
20	CHANGE_EXPLANATION	Character(254)	VARCHAR2(254) NOT NULL	Change Explanation
21	PRIORITY_EXPLNTION	Character(254)	VARCHAR2(254) NOT NULL	Priority Explanation
22	BUSINESS_IMPACT	Character(254)	VARCHAR2(254) NOT NULL	Description
23	FINANCIAL_IMPACT	Number(27,3)	DECIMAL(26,3) NOT NULL	Financial Impact
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
25	IMPACT_DT	Date(10)	DATE	Date
26	APPROVER_COMMENT	Character(254)	VARCHAR2(254) NOT NULL	Approval Comments
27	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
28	CHC_USER1	Character(15)	VARCHAR2(15) NOT NULL	Change request User Field1
29	CHC_USER2	Character(15)	VARCHAR2(15) NOT NULL	Change request User Field2
30	CHC_USER3	Character(15)	VARCHAR2(15) NOT NULL	Change request User Field3
31	CHC_USER4	Character(15)	VARCHAR2(15) NOT NULL	Change request User Field4
32	CHC_USER5	Character(15)	VARCHAR2(15) NOT NULL	Change request User Field5
33	CHC_USER6	Character(15)	VARCHAR2(15) NOT NULL	Change request User Field6
34	CHC_USERAMT1	Number(27,3)	DECIMAL(26,3) NOT NULL	Change Request Additional field for amount
35	CHC_USERAMT2	Number(27,3)	DECIMAL(26,3) NOT NULL	Change Request Additional field for amount
36	CHC_USER_DT1	Date(10)	DATE	Change Request additional user fields for date
37	CHC_USER_DT2	Date(10)	DATE	Change Request additional user fields for date
38	PC_USER_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	User Currency Default Value: PROJECT.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
39	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
40	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
41	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
42	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.