GPBR_ES_ENAB_VW(SQL View) |
Index Back |
|---|---|
Companies eSocial enableCompanies eSocial enable |
| SELECT A.COMPANY ,A.GPBR_ES_PS ,B.ENABLED , C.GPBR_COMP_STATUS FROM PS_GPBR_C_PARM_SRC A , PS_GPBR_ESOC_PARAM B , PS_GPBR_COMP_P_EFF C WHERE A.COMPANY=C.COMPANY AND C.EFFDT=( SELECT MAX(K.EFFDT) FROM PS_GPBR_COMP_P_EFF K WHERE K.COMPANY=A.COMPANY AND K.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 3 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag indicates whether this row is enabled or not. |
| 4 | GPBR_COMP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
eSocial- Company Status.
D=Disabled E=Enabled |