GPCH_FILE_IDGPCH_AUDT_INTVW(SQL View) |
Index Back |
|---|---|
GPCH Audit - Internal File VWGPCH Audit - Internal File VW |
| SELECT DISTINCT A.GPCH_FILE_ID , B.COMPANY , B.GPCH_RC_PAY_YEAR , B.GPCH_EG_DOMAINID FROM PS_GPCH_ATTACH_REF A , PS_GPCH_EG_FSTATUS B , PS_GPCH_EG_PSTATUS C WHERE A.ATTACHUSERFILE = B.FILENAME AND B.GPCH_EG_REQUEST_ID = C.GPCH_EG_REQUEST_ID AND B.GPCH_EG_DOMAINID = C.GPCH_EG_DOMAINID AND B.GPCH_RC_PAY_YEAR = C.GPCH_RC_PAY_YEAR AND C.GPCH_SI_PROV_TYPE = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_FILE_ID |
Character(128) | VARCHAR2(128) NOT NULL | GPCH File ID Field |
| 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 |