GP_PKG_RR1_VW(SQL View) |
Index Back |
---|---|
Packaging View-Rounding RuleThis is a Packaging View. It is used to move Rounding Rules between databases. |
SELECT PIN_NUM + 50000000 , EFFDT , EFF_STATUS , RND_OPTION , RND_SIZE , RND_TYPE , RND_DEC_OR_DGT , RND_SIZE_NUM , RND_SIZE_INC , RND_ADJ_NUM , RND_ADJ_INC , GP_VERSION FROM PS_GP_ROUND_RULE |
# | 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
Default Value: %Date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | RND_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Option
1=Rounding 2=Increment Default Value: 1 |
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
Default Value: 5 |
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. |