BUD_REF_EDR (SQL Table)	Index Back
ERD Table Budget Reference Effective Date Range Table: This table maintains the chartfield values with the effective date range fields EFFDT and INEFFDT.

BUD_REF_EDR

(SQL Table)

ERD Table Budget Reference

Effective Date Range Table: This table maintains the chartfield values with the effective date range fields EFFDT and INEFFDT.

# 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 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 INEFFDT Date(10) DATE NOT NULL Effective Date

5 DTTM_STAMP DateTime(26) TIMESTAMP NOT NULL Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

6 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

#	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	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	INEFFDT	Date(10)	DATE NOT NULL	Effective Date
5	DTTM_STAMP	DateTime(26)	TIMESTAMP NOT NULL	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update