SS_LINK_TBL(SQL Table) |
Index Back |
|---|---|
Direct Reports Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSPNLGRPDFN_VW1 |
| 2 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
| 3 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
| 4 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: PSMENUITEM_VW1 |
| 5 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: PSMENUITEM_VW2 |
| 6 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PSMENUITEM_VW3 |
| 7 | ACCESS_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
A=Add C=Correction L=Update/Display All U=Update/Display |
| 8 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW |
| 9 | ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type
1=By Dept Security Tree 2=By Supervisor Id 3=By Department Manager Id 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group Id |
| 10 | HR_TRANS_NAME | Character(80) | VARCHAR2(80) NOT NULL | Transaction Name |
| 11 | MULTIPLE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Select
Y/N Table Edit Default Value: N |
| 12 | MSG_SET_CONTINUE | Number(5,0) | INTEGER NOT NULL | Continue Message Set |
| 13 | MSG_SET_PAGE_TITLE | Number(5,0) | INTEGER NOT NULL | Page Title Message Set |
| 14 | MSG_SET_PG_INST | Number(5,0) | INTEGER NOT NULL | Page Instructions Message Set |
| 15 | MESSAGE_CONTINUE | Number(5,0) | INTEGER NOT NULL | Continue Message |
| 16 | MESSAGE_PAGE_TITLE | Number(5,0) | INTEGER NOT NULL | Page Title Message |
| 17 | MESSAGE_PG_INST | Number(5,0) | INTEGER NOT NULL | Page Instructions Explanation |
| 18 | UPDATE_OWN_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Update Own Info
Y/N Table Edit Default Value: N |
| 19 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL | This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. |