SPF_WO_ALERT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
3	SP_ALERT_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Alert Sequence Number
4	SP_WO_ALERT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Alert Type A=Days After B=Days Before C=Percent Consumed
5	SP_ALERT_NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days/% Consumed Default Value: 0
6	SP_ALERT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Alert Description
7	SP_ALRT_TRIG_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Alert Triggering Event AE=Actual End Date AP=Approval Date AS=Actual Start Date CL=Closed Date CN=Cancel Date EN=Entered Date PE=Projected End Date PS=Projected Start Date RE=Released Date TE=Terminated Date
8	SP_DSTRLST_ID	Character(18)	VARCHAR2(18) NOT NULL	Distribution List ID Prompt Table: SP_DSTRLST_ACTV