RS_POOL_ERRORS

(SQL View)
 Index Back

Staging table for Pool Changes

Staging table used for loading Pool Changes on mass pool changes batch process

SELECT SEQ_NUM , LOAD_STS , POOL_ACTION , POOL_ID , DESCR , MANAGER_ID , STATUS , PARENT_POOL_ID ,DESCR_2 , DESCR254 , MESSAGE_SET_NBR , MESSAGE_NBR FROM %Table(RS_INTFPOOL_TMP) 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_ACTION Character(1) VARCHAR2(1) NOT NULL Pool Action
A=Add
C=Change
4 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

Prompt Table: RS_RES_POOL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

Prompt Table: RS_ACT_EMPL
Set Control Field: MANAGER_ID

7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

8 PARENT_POOL_ID Character(10) VARCHAR2(10) NOT NULL Parent Pool ID

Prompt Table: RS_RES_POOL

9 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Description
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.