RB_ERMS_PER_GRP(SQL Table) |
Index Back |
|---|---|
ERMS Person Grp WrklistERMS PErson Grp Wrklist information for Suggested worklist |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RB_PERS_NAME_V5 |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | AGENT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Agent Name |
| 4 | RB_WF_GRP_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Group Worklist Nameg
Prompt Table: RB_PER_GRPWLIST |
| 5 | APPRV_PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table: RB_PERS_NAME_V5 |
| 6 | APPROV_PERS_NAME | Character(50) | VARCHAR2(50) NOT NULL | Approving Person |
| 7 | EXT_REPLY_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL |
Reply By Email Address is the default ddress used in message replies sent from the ERMS Framework
Prompt Table: RB_MBOX_REPL_V1 |
| 8 | INT_HR_REPLY_ADDR | Character(254) | VARCHAR2(254) NOT NULL |
Reply By Email Address is the default ddress used in message replies sent from the ERMS Framework
Prompt Table: RB_MBOX_REPL_V2 |
| 9 | INT_REPLY_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL |
Reply By Email Address is the default ddress used in message replies sent from the ERMS Framework
Prompt Table: RB_MBOX_REPL_V3 |
| 10 | HE_REPLY_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL |
Higher Education Reply Email Address
Prompt Table: RB_MBOX_REPL_V4 |
| 11 | RB_EM_APPROV_N | Character(4) | VARCHAR2(4) NOT NULL |
Email approval frequency
0000=Never 0001=All 0005=1 out of 5 0010=1 out of 10 0015=1 out of 15 0020=1 out of 20 0025=1 out of 25 0050=1 out of 50 0100=1 out of 100 Default Value: 0000 |
| 12 | USE_EMLWRKSPC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag to indicate to use Email Workspace while responding to an existing Email |