AP_MTH_RULETYPE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  MTCH_RULE_TYPE |
Character(15) | VARCHAR2(15) NOT NULL | Match Rule Type |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | AP_DM_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Allow Auto Ovrd - Debit Memo
Y/N Table Edit Default Value: N |
| 4 | AP_EXCPT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Allow Exception Action
Y/N Table Edit Default Value: N |
| 5 | AP_MATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Allow Match Action
Y/N Table Edit Default Value: N |
| 6 | AP_OVERRIDE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Allow Override
Y/N Table Edit Default Value: N |
| 7 | AP_LOG_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Allow Log Message Action
Y/N Table Edit Default Value: N |
| 8 | AP_MTCH_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Allow Match with Exception
Y/N Table Edit Default Value: N |
| 9 | WORKFLOW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Flag
Y/N Table Edit Default Value: N |
| 10 | SEND_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Action Workflow Flag
Y/N Table Edit Default Value: N |
| 11 | DAYS_NOTIFY | Number(4,0) | SMALLINT NOT NULL | Totals Days before notification of expiration, renewal, etc. |
| 12 | USER_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
User List Source
C=Application Class Q=Query R=Role S=SQL Definition Default Value: R |
| 13 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
| 14 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE Prompt Table: SQLID_VW |
| 15 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Query Name
Prompt Table: PSQRYDEFN |