RE_MARKER (SQL View)	Index Back
Marker View This is Used in Lease Options Setup to Default Tag Name will carry field value of Translate Table to the page and in page we will display required information. But setid here will bring a cartesian result and will be filtered by the component processor.

RE_MARKER

(SQL View)

Marker View

This is Used in Lease Options Setup to Default Tag Name will carry field value of Translate Table to the page and in page we will display required information. But setid here will bring a cartesian result and will be filtered by the component processor.

SELECT B.SETID , A.FIELDVALUE FROM PSXLATITEM A , PS_SETID_TBL B WHERE A.FIELDNAME = 'TAG_NAME'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: SHARE
Prompt Table: SP_SETID_NONVW

2 TAG_NAME Character(4) VARCHAR2(4) NOT NULL It is used to populate translate values for name in RE_FLD_SEL_WRK work record.
1=Lease Number
2=Lease Title
3=SAR ID
4=SAR Title
5=Option Name
6=Action Date
7=Message