ESTABIDEFFDTDefault Value: %date
SSN_EMPLOYERA=Active
I=Inactive
Default Value: A
Prompt Table: INDSTRY_ACT_ESP
GPES_ESTAB_VW(SQL View) |
Index Back |
|---|---|
Establishment CCC dataEstablishment CCC data |
| SELECT A.ESTABID ,A.EFFDT ,B.SSN_EMPLOYER ,A.EFF_STATUS ,B.INDSTRY_CD_ESP FROM PS_ESTAB_TBL A , PS_ESTAB_SSEC_ESP B WHERE A.ESTABID = B.ESTABID AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | INDSTRY_CD_ESP | Character(5) | VARCHAR2(5) NOT NULL |
Industry Activity Code
Prompt Table: INDSTRY_ACT_ESP |