TRANSACTION_NAMESS_USER_TYPEA=Administrator
E=Employee
M=Manager
SS_COMP_USEADM=Administrator
APL=Approval List
APR=Approver
COR=Core
ORG=Originator
STL=Status List
STS=Status
A=Add
C=Correction
L=Update/Display All
U=Update/Display
SS_BP_COMPS(SQL Table) |
Index Back |
|---|---|
SS Framework Bus Prc ComponentUsed in Self Service Framework. Record that stores the list of all the components and menu references to that component used in a self service process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 2 | SS_USER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Used in SS Framework
A=Administrator E=Employee M=Manager |
| 3 | SS_COMP_USE |
Character(3) | VARCHAR2(3) NOT NULL |
Used in SS Framework
ADM=Administrator APL=Approval List APR=Approver COR=Core ORG=Originator STL=Status List STS=Status |
| 4 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 5 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Bar Name |
| 6 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL | Item Name |
| 7 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 8 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 9 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 10 | ACCESS_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Access Mode
A=Add C=Correction L=Update/Display All U=Update/Display |
| 11 | 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. |