HP_RDIST_TRIGGR (SQL Table)	Index Back
Dept Budget Period Dates This record is the header record for the Department Budgeting Process. It contains one record for each budget period and defines the characteristics of the budget period such as start and end dates, fiscal year, and currency type.

HP_RDIST_TRIGGR

(SQL Table)

Dept Budget Period Dates

This record is the header record for the Department Budgeting Process. It contains one record for each budget period and defines the characteristics of the budget period such as start and end dates, fiscal year, and currency type.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

4 HP_TRANSACTION_SRC Character(1) VARCHAR2(1) NOT NULL Retro Distribution Transaction Source
B=Budget Changes
R=Direct Access Changes

5 TO_DATE Date(10) DATE Latest Date to be sent to PYR

6 FROM_DATE Date(10) DATE From Date

7 PAY_END_DT Date(10) DATE Pay Period End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	HP_TRANSACTION_SRC	Character(1)	VARCHAR2(1) NOT NULL	Retro Distribution Transaction Source B=Budget Changes R=Direct Access Changes
5	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
6	FROM_DATE	Date(10)	DATE	From Date
7	PAY_END_DT	Date(10)	DATE	Pay Period End Date