PMT_SEC_ROLE_RU(SQL Table) |
Index Back |
---|---|
Payment Security Role RulesRules tied to a role. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
2 | RULE_ID | Character(20) | VARCHAR2(20) NOT NULL |
Rule ID
Prompt Table: PMT_SEC_RULE_VW |
3 | PMT_RULE_FIELD_ID | Character(18) | VARCHAR2(18) NOT NULL | Unique identifier for a field referenced in a rule. |
4 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |