CS_DOC_SIGNP_VW

(SQL View)
 Index Back

List of Internal signers

Date Initials Issue Description ============================================ 09/2007 CEL F-AHAYT-25EQ8 view to show the list of internal signers for a document

SELECT A.CS_DOC_ID ,A.CS_COLLAB_OPRID , B.ROLEUSER_ALT , B.EFFDT_FROM , B.EFFDT_TO FROM PS_CS_DOC_COL_USER A , PSROLEXLATOPRVW B WHERE CS_SIGNER_FLG = 'Y' AND B.OPRID = A.CS_COLLAB_OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
2 CS_COLLAB_OPRID Character(30) VARCHAR2(30) NOT NULL User

Prompt Table: PSOPRDEFN_VW

3 ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User
4 EFFDT_FROM Date(10) DATE Effective Date From
5 EFFDT_TO Date(10) DATE Effective Date To