SCC_ORG_TYP_NAV(SQL Table) |
Index Back |
|---|---|
Organization Type NavigationExternal Organization Type Navigation Entries |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EXT_ORG_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Organization Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: SCC_ORG_TYP_TBL.EFFDT |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | DL_LINK_ID | Character(30) | VARCHAR2(30) NOT NULL | Dynamic Link |
| 5 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN |
| 6 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table: PSMENUITEM_VW1 |
| 7 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table: PSMENUITEM_VW2 |
| 8 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PSMENUITEM_VW3 |
| 9 | ACCESS_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
A=Add C=Correction L=Update/Display All U=Update/Display |
| 10 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |