FC_PROJ_TIME_VW

(SQL View)
 Index Back

FC Review Project Time

This view returns a list of every employee who has time forecasted for a PC BU and project id.

SELECT D.BUSINESS_UNIT_PC , D.PROJECT_ID , H.EMPLID , H.BEGIN_DT , H.BEGIN_DT , D.LINE_NBR , CT.END_DT , H.EX_LINE_STATUS , H.BUSINESS_UNIT_GL , D.PROJ_ROLE , H.JOBCODE , D.ACTIVITY_ID , D.BILLING_ACTION , D.TOTAL_HOURS , D.REMAINING_HRS , D.TOTAL_HOURS + D.REMAINING_HRS , D.FORECAST_LEVEL , D.APPROVAL_STATUS , D.COMPLETION_DATE FROM PS_FC_TIME_HDR H , PS_FC_TIME_DTL D , PS_FC_CTRL_TBL CT WHERE D.EMPLID = H.EMPLID AND D.BEGIN_DT = H.BEGIN_DT AND CT.BUSINESS_UNIT_GL = H.BUSINESS_UNIT_GL AND CT.BEGIN_DT = H.BEGIN_DT AND CT.PERIOD = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EFFDT Date(10) DATE Effective Date
5 BEGIN_DT Date(10) DATE Begin Date
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 END_DT Date(10) DATE End Date
8 EX_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNC=Denied
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=Hold by Approver
HDU=Hold by Auditor
HLD=Hold
MFS=Marked For Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
STG=Staged
SUB=Submitted
XML=Submitted, Pending Validation
9 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
10 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
11 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
12 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PC_ACTEAM_TE_VW

13 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
14 TOTAL_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Total Hours
15 REMAINING_HRS Number(8,2) DECIMAL(7,2) NOT NULL Remaining Hours
16 TOT_REMAINING_HRS Number(8,2) DECIMAL(7,2) NOT NULL Total Remaining Hours
17 FORECAST_LEVEL Character(1) VARCHAR2(1) NOT NULL Forecast Level
A=Project/Activity
P=Project
18 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
D=Denied
E=Sent Back for Revision
H=On Hold
I=Initial
M=Resubmitted
P=In Process
R=Rerouted
S=Submitted
19 COMPLETION_DATE Date(10) DATE Completion Date