SCC_RULE_LV_SRC (SQL View)	Index Back
Rules Engine LOV Search This view is used to search for a valid LOV in the rules engine.

SCC_RULE_LV_SRC

(SQL View)

Rules Engine LOV Search

This view is used to search for a valid LOV in the rules engine.

SELECT A.SCC_LOV_UID ,A.SCC_SL_LOV_CONTEXT ,A.RECNAME ,A.FIELDNAME ,A.DESCR ,X.XLATLONGNAME ,A.EDITTABLE ,A.PROMPTFIELD FROM PS_SCC_SL_LOV_HDR A , PSXLATITEM X WHERE X.FIELDNAME = 'SCC_LOV_TYPE' AND X.FIELDVALUE = A.SCC_LOV_TYPE AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn AND X1.EFF_STATUS = 'A')

Related Language Record: SCC_RULE_LV_SRL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID

2 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 SCC_RULE_LOV_TDSCR Character(30) VARCHAR2(30) NOT NULL This field is used to hold the LOV Type translate value in the search views in the rules engine.

7 SCC_RULE_LOV_RCRD Character(15) VARCHAR2(15) NOT NULL This field contains the LOV prompt edit table record used by the LOV framework to find the prompt on record.field.

8 SCC_RULE_LOV_FIELD Character(18) VARCHAR2(18) NOT NULL This field contains the LOV prompt field used by the prompt record used by the LOV framework to find the prompt on record.field.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_LOV_UID	Character(40)	VARCHAR2(40) NOT NULL	LOV Unique ID
2	SCC_SL_LOV_CONTEXT	Character(25)	VARCHAR2(25) NOT NULL	LOV Context
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSRECFIELDALL
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	SCC_RULE_LOV_TDSCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used to hold the LOV Type translate value in the search views in the rules engine.
7	SCC_RULE_LOV_RCRD	Character(15)	VARCHAR2(15) NOT NULL	This field contains the LOV prompt edit table record used by the LOV framework to find the prompt on record.field.
8	SCC_RULE_LOV_FIELD	Character(18)	VARCHAR2(18) NOT NULL	This field contains the LOV prompt field used by the prompt record used by the LOV framework to find the prompt on record.field.