COMPANYGPES_YEARGPES_MONTHSSN_EMPLOYER1=Regular
2=Apprenticeship
3=Training
GPES_CRT_SS_VW(SQL View) |
Index Back |
|---|---|
CRT CCC Prompt ViewCRT CCC Prompt View |
| SELECT DISTINCT A.COMPANY , A.GPES_YEAR , A.GPES_MONTH , A.SSN_EMPLOYER , B.SSN_EMPL_TYPE , B.DESCR FROM PS_GPES_CRT_CMP_VW A , PS_ESTB_CCC_ALL_VW B WHERE A.COMPANY = B.COMPANY AND A.SSN_EMPLOYER = B.SSN_EMPLOYER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPES_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 3 | GPES_MONTH |
Number(2,0) | SMALLINT NOT NULL | Month |
| 4 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 5 | SSN_EMPL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Social Security Number Type
1=Regular 2=Apprenticeship 3=Training |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |