GPBR_RC_ANNDIRF

(SQL Table)
Index Back

DIRF Run Control

DIRF 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