SCC_RL_EDS_SRCH

(SQL View)
Index Back

Rules Engine EDS Search

This record is used to search for data sets used in the rules engine.

SELECT A.SCC_ENTITY_ID , B.SCC_ENT_PRFL_NAME , A.SCC_ENTITY_NAME , B.SCC_ENT_PRFL_ID , A.SCC_STATUS , A.SCC_ENT_LOCK , A.SCC_ENTITY_TYPE_ID , A.SCC_ENTITY_DESCR , A.SCC_APPCLASSNAME , A.SCC_RECNAME , A.SCC_STG_RECNAME , A.SCC_ELEMENT_NAME , A.SCC_APPLY_UPD_RULE , A.SCC_ENTITY_MSG FROM PS_SCC_ENTITY_REG A LEFT OUTER JOIN PS_SCC_RLEDSCAT_VW B ON A.SCC_ENTITY_ID = B.SCC_ENTITY_ID WHERE A.SCC_ENTITY_TYPE_ID='SCC_ETYPE_20130116133604'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
2 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name

Prompt Table: SCC_RLEDSCNM_VW

3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
4 SCC_ENT_PRFL_ID Character(40) VARCHAR2(40) NOT NULL Entity Profile ID
5 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Active
I=Inactive

Default Value: A

6 SCC_ENT_LOCK Number(1,0) SMALLINT NOT NULL Lock

Default Value: 9

7 SCC_ENTITY_TYPE_ID Character(40) VARCHAR2(40) NOT NULL Entity Type ID

Prompt Table: SCC_ENTITY_TYPE

8 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description
9 SCC_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

Prompt Table: SCC_APPCLASS_PT

10 SCC_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

Prompt Table: SCC_REC_PT

11 SCC_STG_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

Prompt Table: SCC_REC_PT

12 SCC_ELEMENT_NAME Character(30) VARCHAR2(30) NOT NULL Element Name

Default Value: DataObject

13 SCC_APPLY_UPD_RULE Character(1) VARCHAR2(1) NOT NULL Apply Data Update Rule

Y/N Table Edit

Default Value: N

14 SCC_ENTITY_MSG Character(60) VARCHAR2(60) NOT NULL Related IB Message

Prompt Table: SCC_MSGVER_PT