PI_IDPrompt Table: PI_CNTL
PI_LINE_NUM0=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
PI_SCAN_RSLT_VW(SQL View) |
Index Back |
|---|---|
PI Scan Results |
| SELECT R.PI_ID , R.PI_LINE_NUM , SCAN.BUSINESS_UNIT , R.ASSET_ID , R.MATCH_STATUS , R1.LOCATION , R2.AREA_ID , R1.OLD_LOCATION , R2.OLD_AREA_ID , R3.DEPTID , R3.OLD_DEPTID , R4.TAG_NUMBER , R4.OLD_TAG_NUMBER , R.PI_ERROR_SW , R.MESSAGE_SET_NBR , R.MESSAGE_NBR , PSMSGCATDEFN.MESSAGE_TEXT , R.HAND_HELD_OPERATOR , P1.NAME , %DatePart(SCAN.LAST_SCAN_DTTM) FROM PS_PI_RESULTS R LEFT OUTER JOIN PSMSGCATDEFN ON R.MESSAGE_SET_NBR = PSMSGCATDEFN.MESSAGE_SET_NBR AND R.MESSAGE_NBR = PSMSGCATDEFN.MESSAGE_NBR , PS_PI_SCAN SCAN , PS_PI_RES_LOCATION R1 , PS_PI_RES_AREA_ID R2 , PS_PI_RES_DEPTID R3 , PS_PI_RES_TAG R4 , %Table(PERSONAL_DATA) P1 , %Table(PSOPRDEFN) P2 WHERE R.PI_ID = SCAN.PI_ID AND R.PI_LINE_NUM = SCAN.PI_LINE_NUM AND R.PI_ID = R1.PI_ID AND R.PI_LINE_NUM = R1.PI_LINE_NUM AND R.PI_ID = R2.PI_ID AND R.PI_LINE_NUM = R2.PI_LINE_NUM AND R.PI_ID = R3.PI_ID AND R.PI_LINE_NUM = R3.PI_LINE_NUM AND R.PI_ID = R4.PI_ID AND R.PI_LINE_NUM = R4.PI_LINE_NUM AND R.HAND_HELD_OPERATOR = P2.OPRID AND P1.EMPLID = P2.EMPLID |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 5 | 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 |
| 6 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 7 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |
| 8 | OLD_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Old Location |
| 9 | OLD_AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | OLD_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Old Department Id |
| 12 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 13 | OLD_TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Old Tag Number |
| 14 | PI_ERROR_SW | Character(1) | VARCHAR2(1) NOT NULL | Error in Physcial Inventory |
| 15 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 16 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 17 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 18 | HAND_HELD_OPERATOR | Character(30) | VARCHAR2(30) NOT NULL | Scanned By |
| 19 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 20 | LAST_SCAN_DTTM | DateTime(26) | TIMESTAMP | Asset Management - Last datetime the asset was scanned (QR Codes). |