SCH_ADHOC_RPT (SQL Table)	Index Back
Scheduled Hours Report Record This record stores the Scheduling data to be printed by the Scheduled Hours Report

SCH_ADHOC_RPT

(SQL Table)

Scheduled Hours Report Record

This record stores the Scheduling data to be printed by the Scheduled Hours Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.

5 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

7 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

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

9 WRKDAY_ID Character(10) VARCHAR2(10) NOT NULL Workday ID

10 SCH_TYPE Character(2) VARCHAR2(2) NOT NULL Shift Type
E=Elapsed
F=Flex
P=Punch

11 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift

12 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

13 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

14 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

15 FLEX_START_TIME Time(15) TIMESTAMP Flex Start Time identifies the earliest time that a Time Reporter working a Flex shift may consider to be the beginning of the shift.

16 FLEX_END_TIME Time(15) TIMESTAMP Flex End Time identifies the latest time that a Time Reporter working a Flex shift may consider to be the end of the shift.

17 START_TIME Time(15) TIMESTAMP Interview Start Time

18 END_TIME Time(15) TIMESTAMP Interview End Time

19 SCHED_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Scheduled Work Hours

20 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
Prompt Table: TL_TRC_TBL

21 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,

22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

24 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

25 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
Prompt Table: LOCAL_TAX_TBL

26 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
Prompt Table: COMP_RT_REG_VW

27 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
N=No
Y=Yes
Y/N Table Edit
Default Value: N

28 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.

29 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

30 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: TL_BUS_UNIT_VW

31 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

32 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: TL_LOCATION_VW

33 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

34 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: TL_DEPT_TBL_VW

35 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

36 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: TL_JOBCODE_VW

37 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

38 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
Prompt Table: TL_PRODUCT_TBL

39 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
Prompt Table: TL_CUSTOMER

40 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
Prompt Table: TL_ACCTCD_BU_VW

41 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL Project Costing Business Unit
Prompt Table: BUS_UNIT_PRJ_VW

42 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit
Prompt Table: BUS_UNIT_TBL_PF

43 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
Prompt Table: %EDIT_PROJECT

44 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity Set ID

45 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

46 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Type
Prompt Table: TL_PROJ_RTYPE_V

47 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource Set ID

48 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Category
Prompt Table: %EDIT_RES_CAT

49 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Project Costing Resource Sub Category
Prompt Table: %EDIT_RES_SUB

50 TASK Character(5) VARCHAR2(5) NOT NULL Task
Prompt Table: TL_TASK

51 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
Prompt Table: TL_USER_FIELD_1

52 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2
Prompt Table: TL_USER_FIELD_2

53 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3
Prompt Table: TL_USER_FIELD_3

54 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4
Prompt Table: TL_USER_FIELD_4

55 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5
Prompt Table: TL_USER_FIELD_5

56 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1
Prompt Table: TL_RULE_ELEMNT1

57 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2
Prompt Table: TL_RULE_ELEMNT1

58 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3
Prompt Table: TL_RULE_ELEMNT3

59 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4
Prompt Table: TL_RULE_ELEMNT4

60 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5
Prompt Table: TL_RULE_ELEMNT5

61 SCH_CONFIG_IND1 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

62 SCH_CONFIG_IND2 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

63 SCH_CONFIG_IND3 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

64 SCH_CONFIG_IND4 Character(1) VARCHAR2(1) NOT NULL Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
5	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
9	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID
10	SCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Shift Type E=Elapsed F=Flex P=Punch
11	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift
12	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
13	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
14	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
15	FLEX_START_TIME	Time(15)	TIMESTAMP	Flex Start Time identifies the earliest time that a Time Reporter working a Flex shift may consider to be the beginning of the shift.
16	FLEX_END_TIME	Time(15)	TIMESTAMP	Flex End Time identifies the latest time that a Time Reporter working a Flex shift may consider to be the end of the shift.
17	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
18	END_TIME	Time(15)	TIMESTAMP	Interview End Time
19	SCHED_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Scheduled Work Hours
20	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor Prompt Table: TL_TRC_TBL
21	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
23	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
24	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
25	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
26	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
27	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Y/N Table Edit Default Value: N
28	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
29	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
30	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: TL_BUS_UNIT_VW
31	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
32	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
33	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
34	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TL_DEPT_TBL_VW
35	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
36	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: TL_JOBCODE_VW
37	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
38	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product Prompt Table: TL_PRODUCT_TBL
39	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
40	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: TL_ACCTCD_BU_VW
41	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit Prompt Table: BUS_UNIT_PRJ_VW
42	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit Prompt Table: BUS_UNIT_TBL_PF
43	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant Prompt Table: %EDIT_PROJECT
44	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity Set ID
45	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
46	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type Prompt Table: TL_PROJ_RTYPE_V
47	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource Set ID
48	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category Prompt Table: %EDIT_RES_CAT
49	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category Prompt Table: %EDIT_RES_SUB
50	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
51	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
52	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
53	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
54	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
55	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5
56	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1 Prompt Table: TL_RULE_ELEMNT1
57	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2 Prompt Table: TL_RULE_ELEMNT1
58	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3 Prompt Table: TL_RULE_ELEMNT3
59	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4 Prompt Table: TL_RULE_ELEMNT4
60	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5 Prompt Table: TL_RULE_ELEMNT5
61	SCH_CONFIG_IND1	Character(1)	VARCHAR2(1) NOT NULL	Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
62	SCH_CONFIG_IND2	Character(1)	VARCHAR2(1) NOT NULL	Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
63	SCH_CONFIG_IND3	Character(1)	VARCHAR2(1) NOT NULL	Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.
64	SCH_CONFIG_IND4	Character(1)	VARCHAR2(1) NOT NULL	Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields.