COMPANYEFFDTDefault Value: %date
GPAR_CMP_TBL_VW(SQL View) |
Index Back |
|---|---|
Company Table ARGCompany Table ARG |
| SELECT A.COMPANY , A.EFFDT , A.CUIT_ARG , A.DGI_ARG , A.ACTIVITY_ARG , A.LAST_PGNBR_ARG , A.COMPANY_ACT_CD_ARG FROM PS_COMPANY_TBL_ARG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMPANY_TBL_ARG B , PS_JOB 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 NOT NULL |
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 |