PI_IDPrompt Table: PI_CNTL
PI_LINE_NUMASSET_ID0=None
1=Special Depr
2=Accelerated Depr
3=Initial Depr
A=All (I,O,U)
D=Discard
I=Inventory
O=Over
R=Retire
U=Under
Y/N Table Edit
PI_RESULTS_VW(SQL View) |
Index Back |
|---|---|
PI Results ViewPI Results view for hardware |
| SELECT A.PI_ID , A.PI_LINE_NUM , A.ASSET_ID , A.MATCH_STATUS , A.REVIEW_SW , A.PI_ERROR_SW , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.HAND_HELD_OPERATOR , B.TAG_NUMBER , B.OLD_TAG_NUMBER , C.SERIAL_ID , C.OLD_SERIAL_ID , D.MODEL , D.OLD_MODEL , E.LOCATION , E.OLD_LOCATION , J.CUSTODIAN , J.OLD_CUSTODIAN , F.EMPLID , F.OLD_EMPLID , G.DESCR , G.OLD_DESCR , H.MANUFACTURER , H.OLD_MANUFACTURER , I.AREA_ID , I.OLD_AREA_ID FROM PS_PI_RESULTS A , PS_PI_RES_TAG B , PS_PI_RES_SERIAL C , PS_PI_RES_MODEL D , PS_PI_RES_LOCATION E , PS_PI_RES_EMPLID F , PS_PI_RES_DESCR G , PS_PI_RES_MANUF H , PS_PI_RES_CUSTOD J , PS_PI_RES_AREA_ID I WHERE A.PI_ID = B.PI_ID AND A.PI_LINE_NUM = B.PI_LINE_NUM AND A.PI_ID = C.PI_ID AND A.PI_LINE_NUM = C.PI_LINE_NUM AND A.PI_ID = D.PI_ID AND A.PI_LINE_NUM = D.PI_LINE_NUM AND A.PI_ID = E.PI_ID AND A.PI_LINE_NUM = E.PI_LINE_NUM AND A.PI_ID = F.PI_ID AND A.PI_LINE_NUM = F.PI_LINE_NUM AND A.PI_ID = G.PI_ID AND A.PI_LINE_NUM = G.PI_LINE_NUM AND A.PI_ID = H.PI_ID AND A.PI_LINE_NUM = H.PI_LINE_NUM AND A.PI_ID = J.PI_ID AND A.PI_LINE_NUM = J.PI_LINE_NUM AND A.PI_ID = I.PI_ID AND A.PI_LINE_NUM = I.PI_LINE_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PI_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Physical Inventory ID
Prompt Table: PI_CNTL |
| 2 | PI_LINE_NUM |
Number(8,0) | INTEGER NOT NULL | PI Line Number |
| 3 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 4 | MATCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PI Match Status
0=None 1=Special Depr 2=Accelerated Depr 3=Initial Depr A=All (I,O,U) D=Discard I=Inventory O=Over R=Retire U=Under |
| 5 | REVIEW_SW | Character(1) | VARCHAR2(1) NOT NULL | Manual Review Required |
| 6 | PI_ERROR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Error in Physcial Inventory
Y/N Table Edit |
| 7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | HAND_HELD_OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | Scanned By |
| 10 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 11 | OLD_TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Old Tag Number |
| 12 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 13 | OLD_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Old Serial Id |
| 14 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
| 15 | OLD_MODEL | Character(30) | VARCHAR2(30) NOT NULL | Old Model |
| 16 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 17 | OLD_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Old Location |
| 18 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Custodian |
| 19 | OLD_CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Old Custodian |
| 20 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 21 | OLD_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Old Emplid |
| 22 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 23 | OLD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Old Description |
| 24 | MANUFACTURER | Character(60) | VARCHAR2(60) NOT NULL | Manufacturer Name |
| 25 | OLD_MANUFACTURER | Character(60) | VARCHAR2(60) NOT NULL | Old Manufacturer |
| 26 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |
| 27 | OLD_AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |