SRM_WL_CRTAPRIO

(SQL Table)
Index Back

WL Prior - Criteria Priority

WL Prior - Criteria Priority

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SP_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner ID
2 SP_OWNER_TYPE Character(3) VARCHAR2(3) NOT NULL Owner Type
3 CRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID
4 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
1=1-High
2=2-Medium
3=3-Low
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive