PC_PRQ_HDR (SQL Table)	Index Back
Project Request Header

PC_PRQ_HDR

(SQL Table)

Project Request Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PC_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL Request Id

2 PC_REQUEST_TYPE Character(5) VARCHAR2(5) NOT NULL Request Type

3 PC_REQUEST_DESCR Character(254) VARCHAR2(254) NOT NULL Request Description

4 PC_REQUEST_STATUS Character(1) VARCHAR2(1) NOT NULL Request Status
A=Approved
B=Pushback
D=Denied
I=In Progress
P=Pending
Default Value: P

5 PC_REQUESTOR Character(30) VARCHAR2(30) NOT NULL Requester

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

7 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: SP_PROJPT_NONVW

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

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_REQUEST_ID	Character(15)	VARCHAR2(15) NOT NULL	Request Id
2	PC_REQUEST_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Request Type
3	PC_REQUEST_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Request Description
4	PC_REQUEST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Approved B=Pushback D=Denied I=In Progress P=Pending Default Value: P
5	PC_REQUESTOR	Character(30)	VARCHAR2(30) NOT NULL	Requester
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
7	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJPT_NONVW
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	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.