EX_TIME_HDR_VW (SQL View)	Index Back
Time Report Header View This is one of the core records for Expenses. It is the highest level definition for a Time Report.

EX_TIME_HDR_VW

(SQL View)

Time Report Header View

This is one of the core records for Expenses. It is the highest level definition for a Time Report.

SELECT TIME_SHEET_ID , VERSION_NUM , EMPLID , PERIOD_END_DT , TIME_SHEET_STATUS , POST_STATUS_EX , EX_ORIGIN , APPROVAL_LEVEL , CREATION_DT , APPROVAL_DT , APPROVAL_OPRID , AUDIT_DT , AUDIT_OPRID , SUBMISSION_DATE , RESUBMISSION_DT , OPRID_LAST_UPDT , BUSINESS_UNIT_GL , DEPTID , EMPL_RCD , PROCESS_INSTANCE , PROCESS_FLAG , OPRID_ENTERED_BY , PROJ_MGR_FLAG , COUNTRY , STATE , SETID , LOCALITY , BILLING_ACTION , COMMENTS , OPRID_SUBMITTED_BY , ACKNOWLEDGE_DTTM , DTL_TOTAL , POL_TOTAL , RISK_EXISTS_FLG , LASTUPDDTTM FROM PS_EX_TIME_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

2 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.

5 TIME_SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Time Sheet Status
ADJ=Adjusted
APR=Approved
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Project Manager
HDA=Hold by Approver
HDU=Hold by Project Manager
HLD=Hold
MFS=Marked for Submit
PAR=Approvals in Process
PND=Pending
PRO=In Process
SFA=Submission in Process
SUB=Submitted for Approval
XML=Submitted, Pending Validation

6 POST_STATUS_EX Character(1) VARCHAR2(1) NOT NULL Expenses Post Status
C=Closed
M=Marked for Unpost
N=Not Applied
O=Unpost In Process
P=Posted
S=Close In Process
U=Unposted

7 EX_ORIGIN Character(1) VARCHAR2(1) NOT NULL Origin of Entry (Expenses)
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web

8 APPROVAL_LEVEL Character(1) VARCHAR2(1) NOT NULL Approval Level
A=Approver Only
B=Pre- and Post-Pay Audit
E=Approver & Pre-Pay Auditor
I=Approve, Pre- & Post-Pay Audit
N=None
S=Approver & Post-Pay Auditor
T=Auditor Only - Post-Payment
U=Auditor Only - Pre-Payment

9 CREATION_DT Date(10) DATE Creation Date

10 APPROVAL_DT Date(10) DATE Date of Approval

11 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

12 AUDIT_DT Date(10) DATE Date of Audit

13 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

14 SUBMISSION_DATE Date(10) DATE Submission Date

15 RESUBMISSION_DT Date(10) DATE Resubmission Date

16 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

17 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

19 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

20 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

21 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

22 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

23 PROJ_MGR_FLAG Character(1) VARCHAR2(1) NOT NULL Project Manager Review

24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

25 STATE Character(6) VARCHAR2(6) NOT NULL State

26 SETID Character(5) VARCHAR2(5) NOT NULL SetID

27 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

28 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable

29 COMMENTS Long Character CLOB Comment

30 OPRID_SUBMITTED_BY Character(30) VARCHAR2(30) NOT NULL Operator Id of user submitting the transaction

31 ACKNOWLEDGE_DTTM DateTime(26) TIMESTAMP Acknowledge Date Time

32 DTL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Total

33 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal

34 RISK_EXISTS_FLG Character(1) VARCHAR2(1) NOT NULL Risk Exists

35 LASTUPDDTTM 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	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
2	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.
5	TIME_SHEET_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Time Sheet Status ADJ=Adjusted APR=Approved DEN=Denied DNA=Denied by Approver DNU=Denied by Project Manager HDA=Hold by Approver HDU=Hold by Project Manager HLD=Hold MFS=Marked for Submit PAR=Approvals in Process PND=Pending PRO=In Process SFA=Submission in Process SUB=Submitted for Approval XML=Submitted, Pending Validation
6	POST_STATUS_EX	Character(1)	VARCHAR2(1) NOT NULL	Expenses Post Status C=Closed M=Marked for Unpost N=Not Applied O=Unpost In Process P=Posted S=Close In Process U=Unposted
7	EX_ORIGIN	Character(1)	VARCHAR2(1) NOT NULL	Origin of Entry (Expenses) A=Asset Lifecycle Management H=Mobile Hand Held Device M=Mobile Time and Expense N=NUI P=Primavera P6 W=Web
8	APPROVAL_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Approval Level A=Approver Only B=Pre- and Post-Pay Audit E=Approver & Pre-Pay Auditor I=Approve, Pre- & Post-Pay Audit N=None S=Approver & Post-Pay Auditor T=Auditor Only - Post-Payment U=Auditor Only - Pre-Payment
9	CREATION_DT	Date(10)	DATE	Creation Date
10	APPROVAL_DT	Date(10)	DATE	Date of Approval
11	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
12	AUDIT_DT	Date(10)	DATE	Date of Audit
13	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
14	SUBMISSION_DATE	Date(10)	DATE	Submission Date
15	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
16	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
17	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
18	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
20	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
21	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
22	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
23	PROJ_MGR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Project Manager Review
24	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
25	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
26	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
27	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
28	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable
29	COMMENTS	Long Character	CLOB	Comment
30	OPRID_SUBMITTED_BY	Character(30)	VARCHAR2(30) NOT NULL	Operator Id of user submitting the transaction
31	ACKNOWLEDGE_DTTM	DateTime(26)	TIMESTAMP	Acknowledge Date Time
32	DTL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total
33	POL_TOTAL	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	PolTotal
34	RISK_EXISTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Risk Exists
35	LASTUPDDTTM	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.