HRMH_TRN_CTLLVW(SQL View) |
Index Back |
---|---|
Matrix Transaction Control TabThis lists the components that can be used as actions with any matrix. It is system data and we will deliver it with no online interface. It drives the transactions available. |
SELECT DISTINCT PNLGRPNAME , A.LANGUAGE_CD , C.PTCS_INSTANCELBL , A.DESCR254 FROM PSPTCSSRVDEFNLG A ,PSPTCSSRVDEFN B , PSPTCSSRVCONFLG C WHERE A.PTCS_SERVICEID = C.PTCS_SERVICEID AND A.PTCS_SERVICEID = B.PTCS_SERVICEID AND A.LANGUAGE_CD = C.LANGUAGE_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | PTCS_INSTANCELBL | Character(50) | VARCHAR2(50) NOT NULL | Service Label |
4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |