EX_TJ_HDR_AW_V2

(SQL View)
 Index Back

Time Report Header Adjust View

Used by the Approval process

SELECT A.TIME_SHEET_ID , A.VERSION_NUM , A.EMPLID , B.FIRST_NAME || ' ' || B.LAST_NAME , CASE WHEN A.STATE <> ' ' THEN A.COUNTRY || '/' || C.DESCR ELSE ' ' END , A.DTL_TOTAL + A.POL_TOTAL , A.POL_TOTAL , %Substring(D.SHORTNAME, 1, 10) , A.BILLING_ACTION , A.VERSION_NUM - 1 FROM PS_EX_TIME_HDR A LEFT OUTER JOIN PS_STATE_TBL C ON A.COUNTRY = C.COUNTRY AND A.STATE = C.STATE , PS_PERSONAL_DATA B , PSDBFLDLABL D WHERE A.EMPLID = B.EMPLID AND D.FIELDNAME = 'FO_HOURS' AND D.DEFAULT_LABEL = 1 AND A.VERSION_NUM = ( SELECT MAX(H2.VERSION_NUM) FROM PS_EX_TIME_HDR H2 WHERE A.TIME_SHEET_ID = H2.TIME_SHEET_ID)

# 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 NAME_60 Character(61) VARCHAR2(61) NOT NULL Name
5 STATE_COUNTRY Character(40) VARCHAR2(40) NOT NULL Country/State
6 TOTAL_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Total Hours
7 POL_TOTAL Signed Number(7,2) DECIMAL(5,2) NOT NULL PolTotal
8 STD_HRS_DESCR Character(10) VARCHAR2(10) NOT NULL Standard Hours description
9 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
10 REVISION_NUMBER Number(3,0) SMALLINT NOT NULL Revision