GPSC_PMRECWH_VW(SQL View) |
Index Back |
---|---|
GPSC_PMRECWH_VWStore data for generating Country install system data |
SELECT P.RECNAME , P.COUNTRY , P.PM_CLAUSE_SEQ , P.PM_CONDITION , P.PM_FIELD_NAME , P.PM_OPERATORS , P.PM_VALUE , P.OBJECTOWNERID FROM PS_PM_PS_REC_WHERE P WHERE (P.OBJECTOWNERID = ( SELECT 'HG' FROM PS_GPSC_CI_GPCEINF WHERE INSTALLED_PAY_GBL='Y') AND P.PM_FIELD_NAME = 'PIN_NUM' AND P.PM_OPERATORS = '<' AND P.PM_VALUE = '2000') OR (P.RECNAME NOT IN ( SELECT N.RECNAME FROM PS_GP_NR_PKG_RECS N WHERE N.GP_PKG_ID LIKE '%SYS') AND P.RECNAME NOT IN ( SELECT M.RECNAME FROM PS_GP_PIN_FLD_MAP1 M WHERE M.RECORD_TYPE_OPT ='R') AND (P.OBJECTOWNERID = ( SELECT 'HG' FROM PS_GPSC_CI_GPCEINF WHERE INSTALLED_PAY_GBL='Y') OR P.OBJECTOWNERID IN ( SELECT OBJECTOWNERID FROM PS_GPSC_OBJOWNID_C ) ) ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
3 | PM_CLAUSE_SEQ | Number(3,0) | SMALLINT NOT NULL | Clause Sequence |
4 | PM_CONDITION | Character(4) | VARCHAR2(4) NOT NULL |
Search Condition
AND=AND CLAUSE WHER=WHERE CLAUSE |
5 | PM_FIELD_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
6 | PM_OPERATORS | Character(2) | VARCHAR2(2) NOT NULL |
Operator
!==!= <=< <==<= === >=> >==>= LK=like NL=not like |
7 | PM_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Value |
8 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |