HR_MTRX_APRVL_V(SQL View) |
Index Back |
|---|---|
Matrix Member Approval View |
| SELECT HRMH_MATRIX_ID , EFFDT , EMPLID , EMPL_RCD , HRMH_MATRIX_TYPE , HRMH_TITLE , HRMH_MEMBER_ROLE , SUPERVISOR_ID , SUPERVIS_EMPL_RCD , START_DT , END_DT , HRMH_MEMBER_STATUS , WF_STATUS FROM PS_HRMH_MATRX_MEMB |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRMH_MATRIX_ID |
Character(15) | VARCHAR2(15) NOT NULL | Matrix Identifier |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HRMH_EMPLID_VW |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | HRMH_MATRIX_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Matrix Type
Default Value: CFR Prompt Table: HRMH_MTRX_TYPE |
| 6 | HRMH_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Hierarchy Member Employee Id |
| 7 | HRMH_MEMBER_ROLE | Character(30) | VARCHAR2(30) NOT NULL | Member Role |
| 8 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL |
Supervisor ID
Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID Prompt Table: HRMH_REPTO_DVW |
| 9 | SUPERVIS_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Supervisor employee record. |
| 10 | START_DT | Date(10) | DATE |
Start Date
Default Value: %date |
| 11 | END_DT | Date(10) | DATE | end date |
| 12 | HRMH_MEMBER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Matrix Member Status
A=Active D=Denied F=Draft I=Inactive P=Pending Default Value: A |
| 13 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |