OBJECTOWNERIDTEMPLATE_IDPNLGRPNAMEPrompt Table: CA_SEC_CMP_VW
MARKETCOMBINATION_NOOPRIDCA_SEC_CMB_VW(SQL View) |
Index Back |
|---|---|
Validation Combinations ViewValidation Template Combinations View |
| SELECT HDR.OBJECTOWNERID ,HDR.TEMPLATE_ID ,CMB.PNLGRPNAME ,CMB.MARKET ,CMB.COMBINATION_NO ,USR.OPRID FROM PS_CA_SEC_TMPL_HDR HDR , PS_CA_SEC_TMPL_CMB CMB , PS_CA_SEC_USER_LST USR WHERE CMB.OBJECTOWNERID = HDR.OBJECTOWNERID AND CMB.TEMPLATE_ID = HDR.TEMPLATE_ID AND HDR.EFF_STATUS = 'A' AND HDR.SEC_TEMPLATE_TYPE='U' AND USR.OBJECTOWNERID = HDR.OBJECTOWNERID AND USR.TEMPLATE_ID = HDR.TEMPLATE_ID UNION SELECT HDR.OBJECTOWNERID ,HDR.TEMPLATE_ID ,CMB.PNLGRPNAME ,CMB.MARKET ,CMB.COMBINATION_NO ,RL.ROLEUSER FROM PS_CA_SEC_TMPL_HDR HDR , PS_CA_SEC_TMPL_CMB CMB , PSROLEUSER RL WHERE HDR.EFF_STATUS = 'A' AND HDR.SEC_TEMPLATE_TYPE='R' AND CMB.OBJECTOWNERID = HDR.OBJECTOWNERID AND CMB.TEMPLATE_ID = HDR.TEMPLATE_ID AND RL.ROLENAME = HDR.ROLENAME AND NOT EXISTS ( SELECT 'X' FROM PS_CA_SEC_EXCL_LST EXC WHERE EXC.OBJECTOWNERID = HDR.OBJECTOWNERID AND EXC.TEMPLATE_ID = HDR.TEMPLATE_ID AND EXC.OPRID = RL.ROLEUSER) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 3 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: CA_SEC_CMP_VW |
| 4 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 5 | COMBINATION_NO |
Number(3,0) | SMALLINT NOT NULL | Combination Number |
| 6 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |