HR_RB_DATA(SQL Table) |
Index Back |
|---|---|
Ratings Box Data RecordRatings Box Data Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HR_RATINGS_BOX_ID |
Character(11) | VARCHAR2(11) NOT NULL | Ratings Box ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | PTCHART_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Chart Node |
| 4 | PTND_DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Node Display Order |
| 5 | PTNODE_DESCR1 | Character(50) | VARCHAR2(50) NOT NULL | Node Description 1 |
| 6 | PTNODEDESCRSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 7 | PTNDDESC1LINKABLE | Character(1) | VARCHAR2(1) NOT NULL |
LinkableDescr Flag1
A=Related Actions On Demand D=Linkable Items DrDn I=Linkable Icon L=Dropdown List Box N=Static Text O=Icon Only R=Read Only Dropdown Y=Yes |
| 8 | PTDESCR1_ICON_IMG | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 9 | PTDESCR1_ICON_POS | Character(1) | VARCHAR2(1) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 10 | PTXAXISRATINGS | Character(20) | VARCHAR2(20) NOT NULL |
X Axis Ratings
Prompt Table:
HR_RB_X_RTNG_VW
|
| 11 | PTYAXISRATINGS | Character(20) | VARCHAR2(20) NOT NULL |
Y Axis Ratings
Prompt Table:
HR_RB_Y_RTNG_VW
|
| 12 | DISPLAYED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Displayed Flag |