RE_OPTION_SRCH(SQL View) |
Index Back |
---|---|
Lease OptionsHolds the setup data for Lease to be used for Critical Dates Notification by Lease Administration |
SELECT A.SETID , A.OPTION_CD , A.INSTANCE_NAME FROM PS_RE_OPTION A WHERE (%CurrentDateIn BETWEEN A.EFFDT AND A.END_EFFDT) OR (A.EFFDT = ( SELECT MIN(C.EFFDT) FROM PS_RE_OPTION C WHERE C.SETID = A.SETID AND C.OPTION_CD = A.OPTION_CD AND C.EFFDT > %CurrentDateIn) AND NOT EXISTS ( SELECT 1 FROM PS_RE_OPTION B WHERE B.SETID = A.SETID AND B.OPTION_CD = A.OPTION_CD AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | OPTION_CD | Character(20) | VARCHAR2(20) NOT NULL | This is used as a Key in the RE_LSE_OPTION record |
3 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Option Name |