RS_RESASG_ERROR

(SQL View)
 Index Back

Staging table for Pool Changes

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

SELECT SEQ_NUM , LOAD_STS , POOL_ASGN_ACTION , EMPLID , POOL_ID , DESCR , START_DATE , END_DATE , CAP_PERCENT , DESCR254 , MESSAGE_SET_NBR , MESSAGE_NBR FROM %Table(RS_INTFC_RESASG) 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: RS_EL_RESASG
Set Control Field: EMPLID

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 START_DATE Date(10) DATE Start Date for Gen Standing PO
8 END_DATE Date(10) DATE End Date
9 CAP_PERCENT Number(3,0) SMALLINT NOT NULL Capacity Percent
10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
11 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.