GP_AUD_RR_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	RND_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Rounding Option 1=Rounding 2=Increment
5	RND_SIZE	Character(3)	VARCHAR2(3) NOT NULL	Rounding Size -01=x0.000000 -02=x00.000000 -03=x,000.000000 -04=x0,000.000000 -05=x00,000.000000 -06=x,000,000.000000 -07=x0,000,000.000000 -08=x00,000,000.000000 -09=x,000,000,000.000000 -10=x0,000,000,000.000000 -11=x00,000,000,000.000000 0=x.000000 01=x.x00000 02=x.xx0000 03=x.xxx000 04=x.xxxx00 05=x.xxxxx0 Prompt Table: GP_RND_SIZE_VW
6	RND_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Type 1=Truncate/Down 2=Up 3=Round Up If >= Else Down
7	RND_DEC_OR_DGT	Character(1)	VARCHAR2(1) NOT NULL	Rounding Decimal/Digit Option 1=ROund Decimals 2=Round Digits
8	RND_SIZE_NUM	Number(3,0)	SMALLINT NOT NULL	Rounding Size Number
9	RND_SIZE_INC	Number(16,6)	DECIMAL(15,6) NOT NULL	Rounding Increment
10	RND_ADJ_NUM	Number(1,0)	SMALLINT NOT NULL	Rounding Adjustment Number
11	RND_ADJ_INC	Number(16,6)	DECIMAL(15,6) NOT NULL	Rounding Adjustment Increment
12	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.
13	GROUPBOX_RR	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.
14	GROUPBOX_RR2	Character(1)	VARCHAR2(1) NOT NULL	Generic groupbox field.