PAY_ENTITYGPNZ_YEARCDGPNZ_MONTHCD01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
GPNZ_IRD_HDR_VW(SQL View) |
Index Back |
|---|---|
Search REC 4 IRD345/6 & 8 INQThis is a search record used for the IRD 345/6 and 8 inquiry. |
| SELECT A.PAY_ENTITY , A.GPNZ_YEARCD , A.GPNZ_MONTHCD , B.DESCR FROM PS_GPNZ_IRD_HEADER A , PS_GP_PYENT B WHERE A.PAY_ENTITY = B.PAY_ENTITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | GPNZ_YEARCD |
Character(4) | VARCHAR2(4) NOT NULL | Year code |
| 3 | GPNZ_MONTHCD |
Character(2) | VARCHAR2(2) NOT NULL |
Month code
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |