ORIG_SYS_REFIMP_ITEM_TYPE_V(SQL View) |
Index Back |
|---|---|
Item Type Oracle ConfigItem Type Oracle Configurator table in CZ database. |
| SELECT PRODUCT_GROUP , DESCRSHORT , DESCR , CZ_SEQUENCE_NUM , 708 FROM PS_PROD_GROUP_TBL A , PS_CZ_SEQUENCE_NUM B WHERE PROD_GRP_TYPE = 'CZ' AND EFF_STATUS = 'A' AND CZ_SEQUENCE_NUM = ( SELECT MAX(CZ_SEQUENCE_NUM) FROM PS_CZ_SEQUENCE_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ORIG_SYS_REF |
Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - ORIG_SYSTEM_REFERENCE |
| 2 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | CZ_RUN_ID | Number(30,0) | DECIMAL(30) NOT NULL | Oracle Configurator field RUN_ID in Oracle eBIZ database. |
| 5 | CZ_SRC_APPLICATION | Number(3,0) | SMALLINT NOT NULL | Oracle Configurator interface table field in eBIZ database. |