GPSC_ELM_RR(SQL View) |
Index Back |
|---|---|
Rounding Rule RecordRounding Rule Record |
| SELECT PIN_NUM , 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 WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , 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_GPSC_RM_RND_RL WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) |
| # | 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. |