COMPANYEFFDTDefault Value: %date
GPAR_ESTAB_VW(SQL View) |
Index Back |
|---|---|
Establishment ARG ViewEstablishment ARG View |
| SELECT COMPANY , EFFDT , CUIT_ARG , DGI_ARG , ACTIVITY_ARG , LAST_PGNBR_ARG , COMPANY_ACT_CD_ARG FROM PS_COMPANY_TBL_ARG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMPANY_TBL_ARG B , PS_ESTAB_TBL C WHERE A.COMPANY = B.COMPANY AND A.COMPANY = C.COMPANY AND B.EFFDT <= C.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | CUIT_ARG | Character(13) | VARCHAR2(13) NOT NULL | CUIT Number ARG |
| 4 | DGI_ARG | Character(30) | VARCHAR2(30) NOT NULL | DGI Office ARG |
| 5 | ACTIVITY_ARG | Character(30) | VARCHAR2(30) NOT NULL | Main Activity ARG |
| 6 | LAST_PGNBR_ARG | Number(6,0) | INTEGER NOT NULL | Last Page Number ARG |
| 7 | COMPANY_ACT_CD_ARG | Character(6) | VARCHAR2(6) NOT NULL | Company Activity Code Field |