R_PER002 (SQL Table)	Index Back
Temp Table for SQR PER002 This is a temporary work area used by the system during SQR report processing for report PER002. You don't need to touch this table.

R_PER002

(SQL Table)

Temp Table for SQR PER002

This is a temporary work area used by the system during SQR report processing for report PER002. You don't need to touch this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

2 DAY_OF_MONTH Number(2,0) SMALLINT NOT NULL Day of the Month

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

6 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name

7 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
2	DAY_OF_MONTH	Number(2,0)	SMALLINT NOT NULL	Day of the Month
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
5	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
6	DEPTNAME	Character(30)	VARCHAR2(30) NOT NULL	Department Name
7	JOBTITLE	Character(30)	VARCHAR2(30) NOT NULL	Job Title