SP_DSTRLACT_VW

(SQL View)
 Index Back

Distribution List Role Views

View used to display Role, fieldname and descriptions tied to a Distribution List

SELECT SP_DSTRLST_ID ,FIELDNAME FROM PS_SP_DSTRLACT A , PS_SP_TRN_ROLE_REG B WHERE A.KEY_01 = B.KEY_01 AND B.TRANNAME = 'WORK_ORDER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SP_DSTRLST_ID Character(18) VARCHAR2(18) NOT NULL Distribution List ID

Prompt Table: SP_DSTRLST

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).