CAGED_RC_BRA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
4	PERIOD_OPTN_BRA	Character(1)	VARCHAR2(1) NOT NULL	Period Option 1=Month 2=Period Default Value: 1
5	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year
6	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
7	DAYOFMONTH	Number(2,0)	SMALLINT NOT NULL	Day of Month
8	DATE_FROM	Date(10)	DATE	Date From
9	DATE_TO	Date(10)	DATE	Previous Period Date To
10	MEDIA_TYPE_BRA	Character(2)	VARCHAR2(2) NOT NULL	Media Type for CAGED file. 10=Diskette 20=Tape 30=Other Default Value: 10
11	ACERTO_IND_BRA	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Generation ACERTO File Y/N Table Edit Default Value: N
12	FIRST_CAGED_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED First Declaration Y/N Table Edit Default Value: N
13	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. Prompt Table: FREQUENCY_TBL
14	DATA_ERR_LOG_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Data Error Log Y/N Table Edit Default Value: N
15	UNEM_INSU_BEN_BRA	Character(1)	VARCHAR2(1) NOT NULL	Unemplyment Insurace Beneficiary BRA Y/N Table Edit Default Value: N
16	INC_MSAL_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Include monthly salary Y/N Table Edit Default Value: Y
17	FILE_NAME_BRA	Character(250)	VARCHAR2(250) NOT NULL	Name of a file, with full path, according to the process scheduler server.
18	DELETE_CAGED_BRA	Character(1)	VARCHAR2(1) NOT NULL	Delete Caged Information Y/N Table Edit Default Value: N
19	RELOAD_CAGED_BRA	Character(1)	VARCHAR2(1) NOT NULL	Reload Caged Information Y/N Table Edit Default Value: N
20	FINALIZE_CAGED_BRA	Character(1)	VARCHAR2(1) NOT NULL	Finalize Caged Information Y/N Table Edit Default Value: N
21	CAGED_REASON10_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
22	CAGED_REASON20_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
23	CAGED_REASON25_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
24	CAGED_REASON31_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
25	CAGED_REASON32_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
26	CAGED_REASON35_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
27	CAGED_REASON40_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
28	CAGED_REASON43_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
29	CAGED_REASON45_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
30	CAGED_REASON50_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
31	CAGED_REASON60_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
32	CAGED_REASON70_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
33	CAGED_REASON80_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y
34	CAGED_REASON90_BRA	Character(1)	VARCHAR2(1) NOT NULL	CAGED Action Reason Code Brazil Y/N Table Edit Default Value: Y