RE_CRDTMPL_SRCH

(SQL View)
 Index Back

Critical Date Template

Used to setup and configure Templates along with the associated Schedule and Role details to be used in Critical Dates Notification by Lease Administration/Critical Date Templates

SELECT A.SETID , A.TEMPLATE_CD , A.INSTANCE_NAME FROM PS_RE_CRDT_TMPLT A WHERE (%CurrentDateIn BETWEEN A.EFFDT AND A.END_EFFDT) OR (A.EFFDT = ( SELECT MIN(C.EFFDT) FROM PS_RE_CRDT_TMPLT C WHERE C.SETID = A.SETID AND C.TEMPLATE_CD = A.TEMPLATE_CD AND C.EFFDT > %CurrentDateIn) AND NOT EXISTS ( SELECT 1 FROM PS_RE_CRDT_TMPLT B WHERE B.SETID = A.SETID AND B.TEMPLATE_CD = A.TEMPLATE_CD AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT))

  • Related Language Record: RE_CRTMPSR_LG

    • # 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 TEMPLATE_CD Character(20) VARCHAR2(20) NOT NULL Template Code
    3 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Template Name