WM_RESCHED_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
3	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
4	RQMT_LN_NBR	Number(5,0)	INTEGER NOT NULL	Requirement Line Number
5	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
6	CREW_BU	Character(5)	VARCHAR2(5) NOT NULL	Crew Business Unit Prompt Table: SP_BU_WM_NONVW
7	CREW_SHOP	Character(10)	VARCHAR2(10) NOT NULL	Crew Shop ID Prompt Table: WM_CREWSHOP_VW
8	CREW_ID	Character(10)	VARCHAR2(10) NOT NULL	Crew Name Prompt Table: WM_PREFCREW_VW
9	SCHED_PATTERN	Character(5)	VARCHAR2(5) NOT NULL	Schedule Pattern
10	PERIOD_START_DT	Date(10)	DATE	Represents the date commencement point for a given time set utilized in cash worksheet processing.
11	SCHED_START_DT	Date(10)	DATE	Scheduled Start Date
12	SCHED_START_TIME	Time(15)	TIMESTAMP	Schedule Start Time
13	SCHED_END_DT	Date(10)	DATE	Scheduled End Date
14	SCHED_END_TIME	Time(15)	TIMESTAMP	Schedule End Time
15	CREW_SCHED_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Crew Schedule Status 1=Unscheduled 2=Scheduled 3=Unplanned / Emergency 4=Schedule Confirmed
16	WO_SCHED_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Scheduled Hours
17	REMAINING_MAN_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Carryover Hours
18	COMPLETE_HRS	Number(15,2)	DECIMAL(14,2) NOT NULL	Completed hours
19	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: WM_CSREASON_TBL
20	CARRYOVER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Carryover Y/N Table Edit Default Value: N
21	DESCRLONG	Long Character	CLOB	Long Description
22	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
23	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser Prompt Table: PSOPRDEFN_VW