BO_CM_TYPE_VW(SQL View) |
Index Back |
---|---|
BO Basics CM TypesBO Basics CM Types used in Basic Data Mapping |
SELECT CM_TYPE_ID , DESCRSHORT FROM PS_CM_TYPE WHERE CM_TYPE_ID IN (1,2,4) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CM_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Contact Method Type ID |
2 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |