FC_TIME_DTL_DLY (SQL Table)	Index Back
Forecast Detail Daily The forecasted time recordings by day for the selected PC business unit, project and activity. There will be more than one row in this table for each row in FC_TIME_DTL (parent table). The field Period is used for identifying which time slice the entry belongs to.

FC_TIME_DTL_DLY

(SQL Table)

Forecast Detail Daily

The forecasted time recordings by day for the selected PC business unit, project and activity. There will be more than one row in this table for each row in FC_TIME_DTL (parent table). The field Period is used for identifying which time slice the entry belongs to.

Parent record: FC_TIME_DTL

# 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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 DATE_UNDER_RPT Date(10) DATE NOT NULL Date Under Report

5 TIME_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Time Quantity

6 PERIOD Number(3,0) SMALLINT NOT NULL Period

#	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	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	DATE_UNDER_RPT	Date(10)	DATE NOT NULL	Date Under Report
5	TIME_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Time Quantity
6	PERIOD	Number(3,0)	SMALLINT NOT NULL	Period