GPCH_EG_REQUEST_IDGPCH_XML_SEL_VW(SQL View) |
Index Back |
|---|---|
GPCH_XML_SEL_VWGPCH_XML_SEL_VW |
| SELECT GPCH_EG_REQUEST_ID ,COMPANY , GPCH_RC_PAY_YEAR ,GPCH_EG_DOMAINID FROM PS_GPCH_EG_FHEADER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_EG_REQUEST_ID |
Character(30) | VARCHAR2(30) NOT NULL | Holds Request ID in the ELM File |
| 2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | GPCH_RC_PAY_YEAR | Number(4,0) | SMALLINT NOT NULL | Pay Year |
| 4 | GPCH_EG_DOMAINID | Number(3,0) | SMALLINT NOT NULL | Domain Set ID for the ELM Domain Sets |