RS_GENRES_TMP (SQL Table)	Index Back
Generic resource schedule date Schedule dates for each resource role of generic resources with PRL status. For each role of generic resources, there are multiple resources. Each of them can have multiple date ranges. All of them are accounted in the sequence number SCHED_NUM. This table will be updated in an application engine and hooks in PRL.

RS_GENRES_TMP

(SQL Table)

Generic resource schedule date

Schedule dates for each resource role of generic resources with PRL status. For each role of generic resources, there are multiple resources. Each of them can have multiple date ranges. All of them are accounted in the sequence number SCHED_NUM. This table will be updated in an application engine and hooks in PRL.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
Prompt Table: RS_POOL_MEMBER

2 MEMBER_ID Number(6,0) INTEGER NOT NULL Member ID.
Prompt Table: RS_POOL_MEMBER

3 SCHED_NUM Number(5,0) INTEGER NOT NULL Team sequence number
Default Value: 1

4 GENERIC_NAME Character(50) VARCHAR2(50) NOT NULL Generic name.

5 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
Default Value: PROJECT_TEAM.PLAN_PROJROLE
Prompt Table: RS_PROJROLE_VW
Set Control Field: SETID_ROLE

6 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.
Prompt Table: SP_SETID_NONVW

7 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee

8 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

9 RESOURCE_STS Character(2) VARCHAR2(2) NOT NULL 11/15/2004 - New field added.
AL=Allocated
CA=Cancelled
CM=Committed
CO=Considered
CP=Completed
RE=Rejected
RQ=Requested

10 PC_HOURS_PER_DAY Number(2,0) SMALLINT NOT NULL Hours per Day

11 AVAIL_UNITS Number(6,0) INTEGER NOT NULL Availability Units

12 START_DATE Date(10) DATE Start Date for Gen Standing PO

13 END_DATE Date(10) DATE End Date

14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

15 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POOL_ID	Character(10)	VARCHAR2(10) NOT NULL	Pool ID field. Prompt Table: RS_POOL_MEMBER
2	MEMBER_ID	Number(6,0)	INTEGER NOT NULL	Member ID. Prompt Table: RS_POOL_MEMBER
3	SCHED_NUM	Number(5,0)	INTEGER NOT NULL	Team sequence number Default Value: 1
4	GENERIC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Generic name.
5	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Default Value: PROJECT_TEAM.PLAN_PROJROLE Prompt Table: RS_PROJROLE_VW Set Control Field: SETID_ROLE
6	SETID_ROLE	Character(5)	VARCHAR2(5) NOT NULL	SetID Role is used in the resource profile to allow select a valid project role. Prompt Table: SP_SETID_NONVW
7	PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Personnel Status E=Employee N=Non-Employee
8	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
9	RESOURCE_STS	Character(2)	VARCHAR2(2) NOT NULL	11/15/2004 - New field added. AL=Allocated CA=Cancelled CM=Committed CO=Considered CP=Completed RE=Rejected RQ=Requested
10	PC_HOURS_PER_DAY	Number(2,0)	SMALLINT NOT NULL	Hours per Day
11	AVAIL_UNITS	Number(6,0)	INTEGER NOT NULL	Availability Units
12	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
13	END_DATE	Date(10)	DATE	End Date
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
15	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField