SCH_ADHOC_DTL (SQL Table)	Index Back
Schedule Ad Hoc Detail The Schedule Ad Hoc Detail table stores time reporter specific detail schedule information. This information may vary from a Time Reporter's long term schedule in terms of when a Time Reporter is schedule to work, and what a Time Reporter is scheduled to work on. This second aspect differentiates this schedule from the Time Reporter's long term schedule which only communicates when a Time Reporter is scheduled to work. The detail schedule may be populated by the Ad Hoc Schedule or Manage Schedule online processes as well as through the Work Force Scheduling interface which accepts schedules from other scheduling applications. For Release 8.0 and beyond, the Scheduling feature is a shared feature, utilized by applications including Time & Labor and Global Payroll.

SCH_ADHOC_DTL

(SQL Table)

Schedule Ad Hoc Detail

The Schedule Ad Hoc Detail table stores time reporter specific detail schedule information. This information may vary from a Time Reporter's long term schedule in terms of when a Time Reporter is schedule to work, and what a Time Reporter is scheduled to work on. This second aspect differentiates this schedule from the Time Reporter's long term schedule which only communicates when a Time Reporter is scheduled to work. The detail schedule may be populated by the Ad Hoc Schedule or Manage Schedule online processes as well as through the Work Force Scheduling interface which accepts schedules from other scheduling applications. For Release 8.0 and beyond, the Scheduling feature is a shared feature, utilized by applications including Time & Labor and Global Payroll.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 SCH_PRIM_ALT_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether this is the employee's Primary or Alternate SChedule
A=Alternate
P=Primary
Default Value: P

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

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

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

7 SCHED_SOURCE Character(2) VARCHAR2(2) NOT NULL Schedule Source indicates the source of Time Reporter Detail Schedule information.
E=Enterprise Learning Management
I=Third Party Import
L=Long Term Schedule
O=On-Line Change

8 PUNCH_DTTM DateTime(26) TIMESTAMP NOT NULL Date and time when the punch occurred.

9 SCH_CATEGORY Character(2) VARCHAR2(2) NOT NULL Schedule Category
AB=Absence Management
MT=Meeting
OT=Other
RE=Replace
TR=Training
WK=Work

10 SCHEDULE_GRP Character(10) VARCHAR2(10) NOT NULL Scheduling Organizational Group Code
Prompt Table: SCH_GROUP_TBL

11 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_VLD_TL_01

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

13 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift
Y/N Table Edit

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

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

16 DELETE_IND Character(1) VARCHAR2(1) NOT NULL Delete Indicator is used to indicate whether a row has been logically deleted.
Y/N Table Edit
Default Value: N

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

58 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.

59 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.

60 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.

61 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.

62 SCH_EXT_FLD1 Character(10) VARCHAR2(10) NOT NULL Schedule External Key Field 1

63 SCH_EXT_FLD2 Character(10) VARCHAR2(10) NOT NULL Schedule External Key Field 2

64 SCH_EXT_FLD3 Character(10) VARCHAR2(10) NOT NULL Schedule External Key Field 2

65 SCH_EXT_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Activity Status
C=Completed
E=Enrolled
I=In Progress

66 SCH_EXT_ACT_TYPE Character(3) VARCHAR2(3) NOT NULL Schedule Activity Type
001=Sessions
002=Webcast

67 ACTIVITY_NAME Character(200) VARCHAR2(200) NOT NULL Activity Name

68 SCH_EXT_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Schedule Event Type
0001=Training
0002=Trainer
001=Training
002=Trainer

69 START_DATE Date(10) DATE Start Date for Gen Standing PO

70 END_DATE Date(10) DATE End Date

71 END_TIME Time(15) TIMESTAMP Interview End Time

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

73 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

74 DATETIME_CREATED DateTime(26) TIMESTAMP DateTime Created

75 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update

76 DATETIME_UPDATED DateTime(26) TIMESTAMP DateTime Updated

77 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
Prompt Table: TL_TASKGRP_TBL

78 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
Prompt Table: TL_TASKGRP_PRFL

79 OVERRIDE_RSN_CD Character(5) VARCHAR2(5) NOT NULL Override Reason Code
Prompt Table: TL_OVRD_RSN_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	SCH_PRIM_ALT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether this is the employee's Primary or Alternate SChedule A=Alternate P=Primary Default Value: P
4	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
5	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	SCHED_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Schedule Source indicates the source of Time Reporter Detail Schedule information. E=Enterprise Learning Management I=Third Party Import L=Long Term Schedule O=On-Line Change
8	PUNCH_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Date and time when the punch occurred.
9	SCH_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Schedule Category AB=Absence Management MT=Meeting OT=Other RE=Replace TR=Training WK=Work
10	SCHEDULE_GRP	Character(10)	VARCHAR2(10) NOT NULL	Scheduling Organizational Group Code Prompt Table: SCH_GROUP_TBL
11	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_TL_01
12	WRKDAY_ID	Character(10)	VARCHAR2(10) NOT NULL	Workday ID
13	OFFDAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Off Day Indicator N=Work Shift Y=Off Shift Y/N Table Edit
14	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
15	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
16	DELETE_IND	Character(1)	VARCHAR2(1) NOT NULL	Delete Indicator is used to indicate whether a row has been logically deleted. Y/N Table Edit Default Value: N
17	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor Prompt Table: TL_TRC_TBL
18	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
20	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
21	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
22	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
23	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
24	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Y/N Table Edit Default Value: N
25	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
26	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
27	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: TL_BUS_UNIT_VW
28	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
29	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
30	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
31	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TL_DEPT_TBL_VW
32	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
33	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: TL_JOBCODE_VW
34	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
35	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product Prompt Table: TL_PRODUCT_TBL
36	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
37	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: TL_ACCTCD_BU_VW
38	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit Prompt Table: BUS_UNIT_PRJ_VW
39	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit Prompt Table: BUS_UNIT_TBL_PF
40	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant Prompt Table: %EDIT_PROJECT
41	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity Set ID
42	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
43	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type Prompt Table: TL_PROJ_RTYPE_V
44	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource Set ID
45	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category Prompt Table: %EDIT_RES_CAT
46	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category Prompt Table: %EDIT_RES_SUB
47	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
48	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
49	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
50	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
51	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
52	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5
53	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1 Prompt Table: TL_RULE_ELEMNT1
54	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2 Prompt Table: TL_RULE_ELEMNT1
55	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3 Prompt Table: TL_RULE_ELEMNT3
56	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4 Prompt Table: TL_RULE_ELEMNT4
57	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5 Prompt Table: TL_RULE_ELEMNT5
58	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.
59	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.
60	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.
61	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.
62	SCH_EXT_FLD1	Character(10)	VARCHAR2(10) NOT NULL	Schedule External Key Field 1
63	SCH_EXT_FLD2	Character(10)	VARCHAR2(10) NOT NULL	Schedule External Key Field 2
64	SCH_EXT_FLD3	Character(10)	VARCHAR2(10) NOT NULL	Schedule External Key Field 2
65	SCH_EXT_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Activity Status C=Completed E=Enrolled I=In Progress
66	SCH_EXT_ACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Schedule Activity Type 001=Sessions 002=Webcast
67	ACTIVITY_NAME	Character(200)	VARCHAR2(200) NOT NULL	Activity Name
68	SCH_EXT_EVENT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Schedule Event Type 0001=Training 0002=Trainer 001=Training 002=Trainer
69	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
70	END_DATE	Date(10)	DATE	End Date
71	END_TIME	Time(15)	TIMESTAMP	Interview End Time
72	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
73	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
74	DATETIME_CREATED	DateTime(26)	TIMESTAMP	DateTime Created
75	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
76	DATETIME_UPDATED	DateTime(26)	TIMESTAMP	DateTime Updated
77	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
78	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID Prompt Table: TL_TASKGRP_PRFL
79	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code Prompt Table: TL_OVRD_RSN_TBL