SCHEDULE_H_TBL (SQL Table)	Index Back
Schedule Date Table Used to store the Dates for a Schedule. A process - Schedule Create is used to blow out the schedule - Define General Option - into a series of dates.

SCHEDULE_H_TBL

(SQL Table)

Schedule Date Table

Used to store the Dates for a Schedule. A process - Schedule Create is used to blow out the schedule - Define General Option - into a series of dates.

Related Language Record: SCHEDULE_H_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
Prompt Table: SCHEDULE_TBL

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

5 END_DATE Date(10) DATE End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID Prompt Table: SCHEDULE_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
5	END_DATE	Date(10)	DATE	End Date