WM_SCHED_RPT1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
5	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
6	RQMT_LN_NBR	Number(5,0)	INTEGER NOT NULL	Requirement Line Number
7	PERIOD_START_DT	Date(10)	DATE	Represents the date commencement point for a given time set utilized in cash worksheet processing.
8	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
9	SCHED_PATTERN	Character(5)	VARCHAR2(5) NOT NULL	Schedule Pattern
10	CRAFT_ID	Character(16)	VARCHAR2(16) NOT NULL	Craft Identification
11	CREW_BU	Character(5)	VARCHAR2(5) NOT NULL	Crew Business Unit
12	CREW_SHOP	Character(10)	VARCHAR2(10) NOT NULL	Crew Shop ID
13	CREW_ID	Character(10)	VARCHAR2(10) NOT NULL	Crew Name
14	SCHED_START_DT	Date(10)	DATE	Scheduled Start Date
15	SCHED_START_TIME	Time(15)	TIMESTAMP	Schedule Start Time
16	SCHED_END_DT	Date(10)	DATE	Scheduled End Date
17	SCHED_END_TIME	Time(15)	TIMESTAMP	Schedule End Time
18	CREW_SCHED_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Crew Schedule Status 1=Unscheduled 2=Scheduled 3=Unplanned / Emergency 4=Schedule Confirmed
19	REMAINING_MAN_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Carryover Hours
20	WO_SCHED_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Scheduled Hours
21	WO_TOT_SCHED_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Total Scheduled Hours
22	ADJ_COMP_SCHED_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Adjusted Comp Sched Hours (b)
23	ADJ_COMPLETE_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Adjusted Completed Hours (c)
24	COMPLETE_SCHED_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Completed Scheduled Hours
25	COMPLETE_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Completed hours
26	COMP_UNPLANNED_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Completed Unplanned Hours
27	CARRYOVER_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Carryover Hours
28	TOT_ACTL_DURATION	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Actual Duration
29	ACTL_COMPLETION_DT	Date(10)	DATE	Actual End Date
30	CREW_TOT_COMP_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Crew Completed Hours
31	CREW_COMPLETION_DT	Date(10)	DATE	Crew Completion Date
32	CARRYOVER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Carryover
33	UNPLANNED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Unplanned
34	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
35	UPDATE_METRICS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Update Crew Schedule Metrics Default Value: N
36	AS_OF_DATE	Date(10)	DATE	As of Date Default Value: %Date