SCRTY_MXRUN_LN(SQL View) |
Index Back |
---|---|
langauge table matrix defnsrelated langauge table of SCRTY_MXRUN_VW |
SELECT b.HRMH_MATRIX_ID ,b.effdt ,b.language_cd ,b.DESCR FROM PS_HRMH_MTRX_DEF_L b |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |