SS_ADM_RULESTP(SQL Table) |
Index Back |
|---|---|
SS Framework Admin StepUsed in Self Service Framework. This is a child of SS_PROC_RULES and is specific to those transactions that use Staged Data and Component Interfaces to update the page. Approval Ruleset object to determine the number and names of approvers in a process. If Database Updates are Not allowed, at least one of the steps in the ApprovalRule object must be identified as the Administrator Used in Self Service Framework. Used in Self Service Framework. step. This record stores which step is the "Administrator Step". |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 2 | SS_CONFIG_OPTION |
Character(1) | VARCHAR2(1) NOT NULL |
Used in SS Framework
1=DB Updates N, Appr Reqd Y 2=DB Updates N, Appr Reqd N 3=DB Updates Y, Appr Reqd Y 4=DB Updates Y, Appr Reqd N 5=CI Administrator Option |
| 3 | APPR_RULE_SET |
Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | APPR_STEP |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1 2=Approval Step 2 3=Approval Step 3 4=Approval Step 4 5=Approval Step 5 6=Approval Step 6 7=Approval Step 7 8=Approval Step 8 9=Approval Step 9 |
| 6 | APPR_PATH |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A B=Approval Path B C=Approval Path C D=Approval Path D E=Approval Path E |
| 7 | ADMIN_STEP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Used in SS Framework
N=No Y=Yes |
| 8 | 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. |