SETIDDefault Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table: SET_VLD_XML
CONTRACT_TYPEPrompt Table: PERS_CNTRCT_TYP
XML_NODE_IDCTPR_COMMBR_VW(SQL View) |
Index Back |
|---|---|
Contract Printing Mapping ESPContract Printing Mapping ESP |
| SELECT COMMBR.SETID , COMMBR.CONTRACT_TYPE ,CNT.DESCR , COMMBR.XML_NODE_ID ,NODE.DESCR50 FROM PS_CTPR_COMMBR_ESP COMMBR , PS_XML_NODE_TBL NODE ,PS_PERS_CNTRCT_TYP CNT WHERE COMMBR.XML_TEMPLATE_ID = 'P01' AND COMMBR.XML_SET = 'P01' AND COMMBR.XML_NODE_ID = NODE.XML_NODE_ID AND COMMBR.XML_SET = NODE.XML_SET AND COMMBR.SETID = CNT.SETID AND COMMBR.CONTRACT_TYPE = CNT.CONTRACT_TYPE AND CNT.EFFDT = ( SELECT MAX (EFFDT) FROM PS_PERS_CNTRCT_TYP WHERE SETID = CNT.SETID AND CONTRACT_TYPE = CNT.CONTRACT_TYPE AND EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: SET_VLD_XML |
| 2 | CONTRACT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table: PERS_CNTRCT_TYP |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | XML_NODE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Root node |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |