SCC_PBLICATN_SA

(SQL Table)
Index Back

CS Publication sibling record

# 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 SCC_MULTI_AUTH Character(1) VARCHAR2(1) NOT NULL Multiple Authors
4 SCC_AUTH_LIST Character(100) VARCHAR2(100) NOT NULL Full Author List
5 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
6 SCC_DATA_VERF Character(1) VARCHAR2(1) NOT NULL Data Verified
7 SCC_VERF_DATE Date(10) DATE Date
8 SCC_VERIFIER Character(11) VARCHAR2(11) NOT NULL Verifier