RS_GENASG_ERROR

(SQL View)
 Index Back

Staging table for Pool Changes

Staging table used for loading Generic Resources assignments on mass pool changes batch process

SELECT SEQ_NUM , LOAD_STS , POOL_ASGN_ACTION , GENERIC_NAME , POOL_ID , DESCR ,SETID_ROLE ,PROJ_ROLE ,REGION_CD ,PER_STATUS , START_DATE , END_DATE , CAP_PERCENT , MESSAGE_SET_NBR , MESSAGE_NBR , DESCR254 FROM %Table(RS_INTFC_GENASG) WHERE LOAD_STS = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
2 LOAD_STS Character(1) VARCHAR2(1) NOT NULL Load Status
E=Error
N=Not Processed
P=Posted
V=Validated
3 POOL_ASGN_ACTION Character(1) VARCHAR2(1) NOT NULL Pool Assignment Action
A=Add
C=Change
D=Delete
4 GENERIC_NAME Character(50) VARCHAR2(50) NOT NULL Generic name.
5 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

Prompt Table: RS_RES_POOL
Set Control Field: POOL_ID

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 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

8 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

Prompt Table: RS_PROJROLE_VW
Set Control Field: SETID_ROLE

9 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.
10 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
11 START_DATE Date(10) DATE Start Date for Gen Standing PO
12 END_DATE Date(10) DATE End Date
13 CAP_PERCENT Number(3,0) SMALLINT NOT NULL Capacity Percent
14 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
15 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
16 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254