SCC_STG_PUBLIC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
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
15	SCC_MULTI_AUTH	Character(1)	VARCHAR2(1) NOT NULL	Multiple Authors Y/N Table Edit
16	SCC_AUTH_LIST	Character(100)	VARCHAR2(100) NOT NULL	Full Author List
17	ADM_APPL_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Application Method DSK=Diskette EDI=EDI HRD=Hard Copy OUA=Ontario University Application SRV=Application Service WWW=Web Application
18	SCC_DATA_VERF	Character(1)	VARCHAR2(1) NOT NULL	Data Verified Y/N Table Edit
19	SCC_VERF_DATE	Date(10)	DATE	Date
20	SCC_VERIFIER	Character(11)	VARCHAR2(11) NOT NULL	Verifier
21	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
22	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
23	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
24	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time