GPBR_RC_ANNDIRF(SQL Table) |
Index Back |
---|---|
DIRF Run ControlDIRF Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPBR_COMPBRA_VW |
4 | ESTAB_ASOC_BRA | Character(12) | VARCHAR2(12) NOT NULL |
Establishment CNPJ Asociated
Prompt Table: GPBR_ESTAB_VW |
5 | GPBR_YEAR_CD | Character(4) | VARCHAR2(4) NOT NULL | Calendar Year |
6 | GPBR_YEAR_REFER | Character(4) | VARCHAR2(4) NOT NULL | Reference Year |
7 | GPBR_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type DIRF
1=Dispossession 2=Termination |
8 | DATE_VALUE | Date(10) | DATE | Date Field for Non-Rule Packager |
9 | GPBR_STAT_DECLAR | Character(1) | VARCHAR2(1) NOT NULL |
Declaration Status
1=Normal 2=Other Default Value: 1 |
10 | GPBR_DEC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Declaration Type
O=Original R=Rectifier Default Value: O |
11 | GPBR_LAST_REC_NBR | Character(12) | VARCHAR2(12) NOT NULL | Las Receipt Number |
12 | GPBR_CTRL_REPORT | Character(1) | VARCHAR2(1) NOT NULL |
Control Report
Y/N Table Edit Default Value: N |
13 | GPBR_OVR_ESTABID | Character(1) | VARCHAR2(1) NOT NULL |
DIRF Establishment ID
Y/N Table Edit Default Value: N |
14 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPBR_ESTAB_VW |
15 | GPBR_OVR_COMPANY | Character(1) | VARCHAR2(1) NOT NULL |
Override Company Responsible
Y/N Table Edit Default Value: N |
16 | GPBR_CRESP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Company Responsible
1=Employee 2=Non Employee Default Value: 1 |
17 | GPBR_CRES_ID | Character(11) | VARCHAR2(11) NOT NULL |
Company Responsible ID
Prompt Table: %EDITTABLE3 |
18 | GPBR_OVR_DIRF | Character(1) | VARCHAR2(1) NOT NULL |
Override DIRF Responsible
Y/N Table Edit Default Value: N |
19 | GPBR_DRESP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Dirf Responsible Override
1=Employee 2=Non Employee Default Value: 1 |
20 | GPBR_DRESP_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible DIRF Override
Prompt Table: %EDITTABLE2 |
21 | GPBR_ID_CODE | Character(7) | VARCHAR2(7) NOT NULL | DIRF identifier code. |