GM_EC_PUB_KP

(SQL View)
Index Back

EDI Publication Info


SELECT '000', A.BUSINESS_UNIT, A.PROPOSAL_ID, A.VERSION_ID, A.SUB_PROP_NBR, A.EMPLID, A.PUBLICATION_ID, C.PUBLICATION_TYPE, C.PUBL_DT, C.PUBLICATION_STATUS, C.PUBLICATION_NAME, C.PUBLICATION_TITLE, C.PUBLISHER, C.ISSUE, C.VOLUME, C.PAGE_NBR, C.NOTES FROM PS_GM_PROP_PROF_PB A, PS_GM_PUBLCN_TBL C WHERE A.PUBLICATION_ID=C.PUBLICATION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECORD_ID Character(3) VARCHAR2(3) NOT NULL Record ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
4 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
5 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 PUBLICATION_ID Character(10) VARCHAR2(10) NOT NULL Publication ID
8 PUBLICATION_TYPE Character(4) VARCHAR2(4) NOT NULL Publication Type
ARTC=Article
BOOK=Book
PRES=Presentation
RECG=Recording
THES=Thesis
VIDE=Video
9 PUBL_DT Date(10) DATE Publication Date
10 PUBLICATION_STATUS Character(2) VARCHAR2(2) NOT NULL Publication Status
AP=Accepted for Publication
ED=Edited
PB=Published
SU=Submitted for Publication
UN=Un-Published
11 PUBLICATION_NAME Character(50) VARCHAR2(50) NOT NULL Publication Name
12 PUBLICATION_TITLE Character(254) VARCHAR2(254) NOT NULL Publication Title
13 PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
14 ISSUE Character(10) VARCHAR2(10) NOT NULL Publication Issue
15 VOLUME Character(10) VARCHAR2(10) NOT NULL Publication Volume
16 PAGE_NBR Character(10) VARCHAR2(10) NOT NULL Page Number(s)
17 NOTES Long Character CLOB Budget Notes