SS_PROC_RULES

(SQL Table)
Index Back

SS Framework Process Rules

Used in Self Service Framework. Approval Ruleset object to determine the number and names of approvers in a process. There should be at least one RuleSet for any transaction that has an approval 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_CONFIG_OPTION Character(1) VARCHAR2(1) NOT NULL Used in SS Framework
1=DB Updates N, Appr Req Y
2=DB Updates N, Appr Req N
3=DB Updates Y, Appr Req Y
4=DB Updates Y, Appr Req N
5=CI Administrator Option
3 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
4 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.