GPCH_RCTX02_VW

(SQL View)
Index Back

GPCH_RCTX02_VW

View for domainid on RC_TX02

SELECT DISTINCT COMPANY , GPCH_EG_DOMAINID FROM PS_GPCH_EG_PTOTALS WHERE GPCH_SI_PROV_TYPE='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets