PY_MOD_CHART_VW(SQL View) |
Index Back |
|---|---|
Paycheck Modeling Chart TablePaycheck Modeling used this record to build a pie chart |
| SELECT ' ' , ' ' , 0 , 0 , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHART_BTN | Character(1) | VARCHAR2(1) NOT NULL | View Chart |
| 2 | PY_MOD_DESCR30 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 3 | PERCENT_OF_TOTAL | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent of Total |
| 4 | PY_MOD_TOTAL_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Paycheck Modeling Percent of Total |
| 5 | PY_MOD_PER_STRING | Character(5) | VARCHAR2(5) NOT NULL | Percent in String |