CANC_MESSAGES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_SF_NONVW
2	BATCH_ID	Character(12)	VARCHAR2(12) NOT NULL	Batch ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
4	BILLING_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Billing Career
5	LINE_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Line Sequence Nbr
6	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
7	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
8	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	BATCH_RUN_DATE	Date(10)	DATE	Batch Run Date
11	SSF_ERROR_WARN	Character(1)	VARCHAR2(1) NOT NULL	Field to hold translate values for Message Types - Error/Warning/Message E=Error M=Message W=Warning
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.