RA_MC_REASG_HDR(SQL Table) |
Index Back |
---|---|
Re-assign Marketing CentersKeep reassignment run parameters |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | RA_MKT_CENTER | Character(10) | VARCHAR2(10) NOT NULL |
Marketing Center code
Prompt Table: RA_MC_REASG_VW |
4 | RA_CHILD_MC | Character(1) | VARCHAR2(1) NOT NULL |
Assignment to take place on prospects that currently match the Marketing Center and all of its Marketing Center children
Default Value: N |
5 | RA_MANUAL_MC | Character(1) | VARCHAR2(1) NOT NULL |
Marketing Centers manually added to prospects will be deleted
Default Value: N |