SERIAL_IDA=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress
IT_SERIAL_ID(SQL View) |
Index Back |
|---|---|
All IT Hardware Serial IDs |
| SELECT SERIAL_ID , MIN(BUSINESS_UNIT ) , MIN(ASSET_ID ) , MIN(ASSET_STATUS ) FROM PS_ASSET WHERE ASSET_TYPE = '010' AND IN_PHY_USE = 'Y' GROUP BY SERIAL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 4 | ASSET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Asset Status
A=Received (Not in Service) B=Budgeted C=Commitment D=Disposed I=In Service M=Suspended R=Requisitioned T=Transferred W=Work In Progress |