HRBP_PARTNER_TYPEABS=Absence Management
BEN=Benefits
HR=Human Resources
OT=Other
PAY=Payroll
TL=Time and Labor
HRMH_MATRIX_TYPEHRBP_MTRXOWN_VW(SQL View) |
Index Back |
|---|---|
MATRIX AND MATRIX TYPEList matrices defined to BP by Matrix Type |
| SELECT B.HRBP_PARTNER_TYPE , A.HRMH_MATRIX_ID , A.HRMH_MATRIX_TYPE , A.HRMH_OWNER_EMPLID FROM PS_HRMH_MATRX_DEFN A , PS_HRBP_CONFIG_TBL B WHERE %EffdtCheck (HRMH_MATRX_DEFN A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.HRMH_MATRIX_ID = A.HRMH_MATRIX_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRBP_PARTNER_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Business Partner Type
ABS=Absence Management BEN=Benefits HR=Human Resources OT=Other PAY=Payroll TL=Time and Labor |
| 2 | HRMH_MATRIX_ID | Character(15) | VARCHAR2(15) NOT NULL | Matrix Identifier |
| 3 | HRMH_MATRIX_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Matrix Type |
| 4 | HRMH_OWNER_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Matrix Owner Employee ID |