GP_PKG_RR1_AD(SQL Table) |
Index Back |
|---|---|
Rounding Rule RecordRounding Rule Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | RND_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Option
1=Rounding 2=Increment |
| 6 | 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 |
| 7 | RND_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Type
1=Truncate/Down 2=Up 3=Round Up If >= Else Down |
| 8 | RND_DEC_OR_DGT | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Decimal/Digit Option
1=ROund Decimals 2=Round Digits |
| 9 | RND_SIZE_NUM | Number(3,0) | SMALLINT NOT NULL | Rounding Size Number |
| 10 | RND_SIZE_INC | Number(16,6) | DECIMAL(15,6) NOT NULL | Rounding Increment |
| 11 | RND_ADJ_NUM | Number(1,0) | SMALLINT NOT NULL | Rounding Adjustment Number |
| 12 | RND_ADJ_INC | Number(16,6) | DECIMAL(15,6) NOT NULL | Rounding Adjustment Increment |
| 13 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |