GP_GCTL_FREQ (SQL Table)	Index Back
Generation Control Frequency This table is used to set up various generation control 'tags' such as 'once a quarter', '31st March' etc. and associate it with an HR frequency id for the annualization factor. This table is used to avoid cluttering up the HR frequency table with stuff that is usually only used with generation control

GP_GCTL_FREQ

(SQL Table)

Generation Control Frequency

This table is used to set up various generation control 'tags' such as 'once a quarter', '31st March' etc. and associate it with an HR frequency id for the annualization factor. This table is used to avoid cluttering up the HR frequency table with stuff that is usually only used with generation control

Related Language Record: GP_GCTL_FRQ_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FREQUENCY_TAG Character(10) VARCHAR2(10) NOT NULL Frequency tag .. used for generation control

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
Prompt Table: FREQUENCY_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FREQUENCY_TAG	Character(10)	VARCHAR2(10) NOT NULL	Frequency tag .. used for generation control
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. Prompt Table: FREQUENCY_TBL