PUBLICATIONS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	PUBLICATION_NBR	Number(3,0)	SMALLINT NOT NULL	Publication Number
3	PUBLICATION_DT	Character(10)	VARCHAR2(10) NOT NULL	Publication Date
4	PUBL_DT	Date(10)	DATE	Publication Date
5	DATE_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Date Format (PowerPlay Only) D1=YY/MM/DD D2=MM/DD/YY D3=DDDD,MMMM DD, YYYY M1=YYYY/MMMM M2=MYY M3=MMMM,YYYY M4=MMMM YYYY Q=YYYY "Q" Q W=YYYY/MM/DD Y1=YYYY Y2=YY Y/N Table Edit Default Value: N
6	PUBLICATION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Publication Type ARTC=Article BOOK=Book PRES=Presentation RECG=Recording THES=Thesis VIDE=Video
7	PUBLICATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Publication Name
8	PUBLICATION_TITLE	Character(254)	VARCHAR2(254) NOT NULL	Publication Title
9	VOLUME	Character(10)	VARCHAR2(10) NOT NULL	Publication Volume
10	ISSUE	Character(10)	VARCHAR2(10) NOT NULL	Publication Issue
11	PAGE_NBR	Character(10)	VARCHAR2(10) NOT NULL	Page Number(s)
12	EG_PUBLISHER	Character(50)	VARCHAR2(50) NOT NULL	Publisher
13	AUTHOR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Author Type AUT=Author COA=Co-Author EDI=Editor
14	NOTES	Long Character	CLOB	Notes