GPSC_PMRECWH_VW

(SQL View)
Index Back

GPSC_PMRECWH_VW

Store 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