GPCH_EG_DTL_VW (SQL View)	Index Back
View for Tax Stmt 2006 View for getting the domainids on the run control page for classic tax statement.

GPCH_EG_DTL_VW

(SQL View)

View for Tax Stmt 2006

View for getting the domainids on the run control page for classic tax statement.

SELECT COMPANY , GPCH_EG_DOMAINID FROM PS_GPCH_EG_DSETDTL WHERE GPCH_SI_PROV_TYPE='8'

# 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

#	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