FC_TIME_HDR (SQL Table)	Index Back
Forecast Header This record is the highest-level definition for capturing forecast data entered by employees. It will contain header information used for identifying forecast data for a specific horizon for a specific employee. Only one record will be created for each employee for a forecast horizon.

FC_TIME_HDR

(SQL Table)

Forecast Header

This record is the highest-level definition for capturing forecast data entered by employees. It will contain header information used for identifying forecast data for a specific horizon for a specific employee. Only one record will be created for each employee for a forecast horizon.

Parent Record Of FC_TIME_DTL FC_TIME_POL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BEGIN_DT Date(10) DATE NOT NULL Begin Date

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

4 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
Default Value: PND

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

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

7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

8 WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day

9 TOTAL_DETAIL Signed Number(9,2) DECIMAL(7,2) NOT NULL Total Detail

10 REMAINING_HRS Number(8,2) DECIMAL(7,2) NOT NULL Remaining Hours

11 TOTAL_POLICY Signed Number(9,2) DECIMAL(7,2) NOT NULL Total Policy

12 LOCK_FCST Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas
Default Value: N

13 CREATION_DT Date(10) DATE Creation Date
Default Value: %date

14 SUBMISSION_DATE Date(10) DATE Submission Date

15 RESUBMISSION_DT Date(10) DATE Resubmission Date

16 LAST_UPDATE_DT Date(10) DATE Last Updated

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

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

19 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N

20 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	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 Default Value: PND
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
8	WORK_DAY_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Number of Hours in a Work Day
9	TOTAL_DETAIL	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Total Detail
10	REMAINING_HRS	Number(8,2)	DECIMAL(7,2) NOT NULL	Remaining Hours
11	TOTAL_POLICY	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Total Policy
12	LOCK_FCST	Character(1)	VARCHAR2(1) NOT NULL	12/24/01 EGS (CN#PL900-1): Merry Christmas Default Value: N
13	CREATION_DT	Date(10)	DATE	Creation Date Default Value: %date
14	SUBMISSION_DATE	Date(10)	DATE	Submission Date
15	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
16	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
17	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Default Value: N
20	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