SERIAL_IDIT_EXCPT_RTF(SQL View) |
Index Back |
|---|---|
Route to Finance InformationRoute to finance information for all potential routing candidates from the Manage Exceptions component |
| SELECT DSP.SERIAL_ID , DSP.DISCO_SERIAL_ID , DSP.BUSINESS_UNIT_AM , DSP.BUSINESS_UNIT_HR , DSP.ASSET_ID , C.ASSET_SUBTYPE , DSP.DEPTID , DSP.EMPLID , C.IP_ADDRESS , DSP.DISCO_MFG_ID , DSP.DISCO_MODEL , DSP.DISCO_LOCATION ,C.DISCOVERY_DATE , DSP.DISCO_IT_UD_CHAR1 , DSP.DISCO_IT_UD_CHAR2 , DSP.DISCO_IT_UD_DATE1 FROM PS_IT_RECON_DSPLY DSP , PS_IT_HRDWR_CACHE C WHERE DSP.SERIAL_ID = C.SERIAL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 2 | DISCO_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 3 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 4 | BUSINESS_UNIT_HR | Character(5) | VARCHAR2(5) NOT NULL | Business Unit HR |
| 5 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 6 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL | Asset Subtype |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | IP_ADDRESS | Character(39) | VARCHAR2(39) NOT NULL | Internet Protocol Address |
| 10 | DISCO_MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Discovery Manufacturer ID |
| 11 | DISCO_MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
| 12 | DISCO_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Discovery Location Code |
| 13 | DISCOVERY_DATE | Date(10) | DATE | Last Inventory Date |
| 14 | IT_UD_CHAR1 | Character(50) | VARCHAR2(50) NOT NULL | IT User Defined Char Field1 |
| 15 | IT_UD_CHAR2 | Character(50) | VARCHAR2(50) NOT NULL | IT User Defined Char Field2 |
| 16 | IT_UD_DATE1 | Date(10) | DATE | IT User Defined Date Field |