HRRATINGBOX(SQL Table) |
Index Back |
|---|---|
HR Rating Box Data RecordHR Rating 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 | PTCHART_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Chart Node |
| 3 | PTND_DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Node Display Order |
| 4 | PTNODE_DESCR1 | Character(50) | VARCHAR2(50) NOT NULL | Node Description 1 |
| 5 | PTNODEDESCRSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 6 | 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 |
| 7 | PTDESCR1_ICON_IMG | Character(30) | VARCHAR2(30) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 8 | PTDESCR1_ICON_POS | Character(1) | VARCHAR2(1) NOT NULL | Name of image that is used for leaf , i.e. detail values in tree |
| 9 | PTXAXISRATINGS | Character(20) | VARCHAR2(20) NOT NULL |
X Axis Ratings
Prompt Table:
HR_RB_X_RTNG_VW
|
| 10 | PTYAXISRATINGS | Character(20) | VARCHAR2(20) NOT NULL |
Y Axis Ratings
Prompt Table:
HR_RB_Y_RTNG_VW
|
| 11 | DISPLAYED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Displayed Flag |