TL_TR_PRDS_VW (SQL View)	Index Back
Time Periods of Day/Week/Month View of Time Reporting Time Periods, which include the following types of Time Periods: Day, Week, and Month.

TL_TR_PRDS_VW

(SQL View)

Time Periods of Day/Week/Month

View of Time Reporting Time Periods, which include the following types of Time Periods: Day, Week, and Month.

SELECT A.PERIOD_ID , A.PERIOD_TYPE ,A.DESCR , DESCRSHORT FROM PS_TL_TIME_PERIODS A WHERE A.PERIOD_TYPE IN ('FW','FM') OR (A.PERIOD_TYPE = 'FD' AND A.OFFSET_DAYS = 1)

Related Language Record: TL_TR_PRDS_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID

2 PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies the type of time period, which impacts the parameters used to define the time period as well as the logic used to generate the resulting calendar.
CO=Complex
FD=Daily
FM=Monthly
FW=Weekly
RE=Repeating

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID
2	PERIOD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies the type of time period, which impacts the parameters used to define the time period as well as the logic used to generate the resulting calendar. CO=Complex FD=Daily FM=Monthly FW=Weekly RE=Repeating
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description