RA_UD_GRDCS_VW(SQL View) |
Index Back |
---|---|
Campaign Grid Status ViewMarketing Campaign - Grid Status View |
SELECT DISTINCT RA_CMPGN_STATUS_CD , DESCR FROM PS_RA_UD_CPGN_STAT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |