AM_MY_REQ_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , ASSET_ID , DTTM_STAMP , OPRID , AM_ASSET_RQST_CODE , AM_APPROVAL_STATUS , DATE_TRANSFER , DATE_STOLEN , DATE_REPORT , DATE_SUBMITTED , DATE_APPROVED , EMPLID , EMPLID_TO , DEPTID , DEPTID_TO , LOCATION , LOCATION_TO , ORIGINATOR_ID , APPROVER_ID , MANAGER_ID , MANAGER_NAME , DESCRLONG FROM PS_AM_MY_ASSET_REQ WHERE AM_APPROVAL_STATUS = '0' OR AM_APPROVAL_STATUS = '3' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | 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. |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | 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 |
| 6 | 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 |
| 7 | DATE_TRANSFER | Date(10) | DATE | Report Date |
| 8 | DATE_STOLEN | Date(10) | DATE | Report Date |
| 9 | DATE_REPORT | Date(10) | DATE | Report Date |
| 10 | DATE_SUBMITTED | Date(10) | DATE | Date Submitted |
| 11 | DATE_APPROVED | Date(10) | DATE | Date Approved |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 13 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL |
EmplID
Prompt Table: PERSONAL_DATA |
| 14 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 15 | DEPTID_TO | Character(10) | VARCHAR2(10) NOT NULL |
To Department
Prompt Table: DEPT_TBL |
| 16 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 17 | LOCATION_TO | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 18 | ORIGINATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Originator |
| 19 | APPROVER_ID | Character(11) | VARCHAR2(11) NOT NULL | Approver ID |
| 20 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager ID |
| 21 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Identifies the name of the manager of a specified department. |
| 22 | DESCRLONG | Long Character | CLOB | Long Description |