RE_CRDT_TMP_CUR (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

RE_CRDT_TMP_CUR

(SQL View)

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 SETID , TEMPLATE_CD , EFFDT , END_EFFDT , INSTANCE_NAME , INSTANCE_DESCR FROM %Table(RE_CRDT_TMPLT) WHERE %CurrentDateIn BETWEEN EFFDT AND END_EFFDT AND EFF_STATUS = 'A'

Related Language Record: RE_CRDTMPLT_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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 END_EFFDT Date(10) DATE Ending effective date established to be used by queries to improve effective-date processing performance.

5 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Template Name

6 INSTANCE_DESCR Character(150) VARCHAR2(150) NOT NULL Generic Description Field for Instances of Generic Entities

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	END_EFFDT	Date(10)	DATE	Ending effective date established to be used by queries to improve effective-date processing performance.
5	INSTANCE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Template Name
6	INSTANCE_DESCR	Character(150)	VARCHAR2(150) NOT NULL	Generic Description Field for Instances of Generic Entities