RA_CMP_WF_AET(SQL Table) |
Index Back |
|---|---|
Campaign Workflow State RecordMarketing Campaign State Record workflow routing used in application engine program |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RULE_NAME | Character(30) | VARCHAR2(30) NOT NULL | This field is a text field of 30 character long. |
| 5 | SCHED_PRCS_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Schedule Process Number.............................................. |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | RA_OWNER_ID | Character(15) | VARCHAR2(15) NOT NULL | Owner ID |
| 8 | RA_TASK_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Marketing - Task Type
Prompt Table: RA_UD_TASK_TYPE |
| 9 | RA_CAMPAIGN_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 10 | RA_CMPGN_STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Valid Campaign and Wave Status Codes
APPR=Approved ARCH=Archived CMPL=Completed DCLN=Declined EXEC=Executing IREV=In Review NEW=New STOP=Stop TRIG=Trigger Approved |
| 11 | RA_TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Status of the task
ASGN=Assigned CANC=Cancelled CMPL=Completed NEW=New task - not assigned OVER=Over Due REJD=Rejected |
| 12 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 13 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |