CS_ADH_DOC_VW (SQL View)	Index Back
Adhoc Document Header January 6, 2016 Created to show bind mappings for adhoc vendor information

CS_ADH_DOC_VW

(SQL View)

Adhoc Document Header

January 6, 2016 Created to show bind mappings for adhoc vendor information

SELECT H.cs_doc_id , H.CNTRCT_STYLE , CASE WHEN H.CNTRCT_STYLE = ' ' THEN ' ' ELSE ( SELECT S.CNTRCT_STYLE_NAME FROM PS_CNTRCT_STYLE S WHERE H.CNTRCT_STYLE = S.CNTRCT_STYLE) END FROM PS_CS_DOC_HDR h

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

2 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
Prompt Table: CS_CNTSTYLE_VW

3 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	CNTRCT_STYLE	Character(10)	VARCHAR2(10) NOT NULL	Contract Style Prompt Table: CS_CNTSTYLE_VW
3	CNTRCT_STYLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Style Description