PNLNAMEPrompt Table: PSPNLDEFN_VW
HR_OC_CHART_NAMEPTNODE_DISPLAY_IDPT_SCHEMA_LEVEL_IDPT_CNT_IDPrompt Table: HR_OC_CNT_ID_VW
Default Value: 1
Default Value: 1
Y/N Table Edit
Default Value: Y
Prompt Table: HR_OC_STYLCL_VW
HR_OC_DISP_TBL(SQL Table) |
Index Back |
|---|---|
OC Framework-Display Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PSPNLDEFN_VW |
| 2 | HR_OC_CHART_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Org Chart Name |
| 3 | PTNODE_DISPLAY_ID |
Character(50) | VARCHAR2(50) NOT NULL | Display Template ID |
| 4 | PT_SCHEMA_LEVEL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Schema Level ID |
| 5 | PT_CNT_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Content ID
Prompt Table: HR_OC_CNT_ID_VW |
| 6 | PT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL |
Line Number
Default Value: 1 |
| 7 | PTND_DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL |
Node Display Order
Default Value: 1 |
| 8 | PT_DISPLAY_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Display Type |
| 9 | PT_DISPLAY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Display Flag
Y/N Table Edit Default Value: Y |
| 10 | PT_PADDING_RIGHT | Number(3,0) | SMALLINT NOT NULL | Right Padding |
| 11 | PT_PADDING_LEFT | Number(3,0) | SMALLINT NOT NULL | Padding Left |
| 12 | PT_CNT_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Content Style
Prompt Table: HR_OC_STYLCL_VW |
| 13 | PT_DESCR_MAX | Number(3,0) | SMALLINT NOT NULL | Maximumn Description |
| 14 | HR_OC_LABEL_FOR | Character(30) | VARCHAR2(30) NOT NULL | Label For |
| 15 | SEQ_NO | Number(2,0) | SMALLINT NOT NULL | Processing Sequence |
| 16 | COMMENTS_256 | Character(254) | VARCHAR2(254) NOT NULL | Comments |