AM_MY_ASSET_FL(SQL View) |
Index Back |
|---|---|
Asset SelfService fluid vwAM_MY_ASSET_REQ view for fluid approval |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , ( SELECT A1.DESCR FROM PS_ASSET A1 WHERE (A1.BUSINESS_UNIT = A.BUSINESS_UNIT AND A1.ASSET_ID = A.ASSET_ID)) , A.DTTM_STAMP , A.OPRID , ( SELECT O1.OPRDEFNDESC FROM PSOPRDEFN O1 WHERE (O1.OPRID = A.OPRID)) , A.AM_ASSET_RQST_CODE , A.AM_APPROVAL_STATUS , A.DATE_TRANSFER , A.DATE_STOLEN , A.DATE_REPORT , A.DATE_SUBMITTED , A.DATE_APPROVED , A.EMPLID , ( SELECT E1.NAME FROM PS_PERSONAL_DATA E1 WHERE (E1.EMPLID = A.EMPLID)) , A.EMPLID_TO , ( SELECT E2.NAME FROM PS_PERSONAL_DATA E2 WHERE (E2.EMPLID = A.EMPLID_TO)) , A.DEPTID , ( SELECT D1.DESCR FROM PS_DEPT_AM_VW D1 WHERE (D1.BUSINESS_UNIT = A.BUSINESS_UNIT AND D1.DEPTID=A.DEPTID)) , A.DEPTID_TO , ( SELECT D2.DESCR FROM PS_DEPT_AM_VW D2 WHERE (D2.BUSINESS_UNIT = A.BUSINESS_UNIT AND D2.DEPTID=A.DEPTID_TO)) , A.LOCATION , ( SELECT L1.DESCR FROM PS_LOCATION_AM_VW2 L1 WHERE (L1.BUSINESS_UNIT = A.BUSINESS_UNIT AND L1.LOCATION=A.LOCATION)) , A.LOCATION_TO ,( SELECT L2.DESCR FROM PS_LOCATION_AM_VW2 L2 WHERE (L2.BUSINESS_UNIT = A.BUSINESS_UNIT AND L2.LOCATION=A.LOCATION_TO)) , A.ORIGINATOR_ID , A.APPROVER_ID , A.MANAGER_ID , A.MANAGER_NAME , A.DESCRLONG FROM PS_AM_MY_ASSET_REQ A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 7 | AM_ASSET_RQST_CODE | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate the request code when an employee's asset is being submited to his/her manager for review.
0=OK. No change necessary 1=Asset Not Assigned to Me 2=Asset Lost or Stolen 3=Transfer Asset 4=Move to another location Default Value: 0 |
| 8 | AM_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to indicate the 'My Asset' update status.
0=Pending 1=Approved 2=Denied 3=Held Default Value: 0 |
| 9 | DATE_TRANSFER | Date(10) | DATE | Report Date |
| 10 | DATE_STOLEN | Date(10) | DATE | Report Date |
| 11 | DATE_REPORT | Date(10) | DATE | Report Date |
| 12 | DATE_SUBMITTED | Date(10) | DATE | Date Submitted |
| 13 | DATE_APPROVED | Date(10) | DATE | Date Approved |
| 14 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 15 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 16 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL |
EmplID
Prompt Table: PERSONAL_DATA |
| 17 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 18 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 19 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 20 | DEPTID_TO | Character(10) | VARCHAR2(10) NOT NULL |
To Department
Prompt Table: DEPT_TBL |
| 21 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 22 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 23 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 24 | LOCATION_TO | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_VW |
| 25 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 26 | ORIGINATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Originator |
| 27 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver ID |
| 28 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager ID |
| 29 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Identifies the name of the manager of a specified department. |
| 30 | DESCRLONG | Long Character | CLOB | Long Description |