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 | Number(6,0) | INTEGER NOT NULL | Contact Method Type ID | |
| 2 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |