WM_BU_OPT_MGREM (SQL Table)	Index Back
Assgn Status for Mgr eMail List of assignment statuses for which eMail notifications will be sent to the Resource Manager. This table is used by Work Management

WM_BU_OPT_MGREM

(SQL Table)

Assgn Status for Mgr eMail

List of assignment statuses for which eMail notifications will be sent to the Resource Manager. This table is used by Work Management

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 ASSIGN_STS Character(2) VARCHAR2(2) NOT NULL Assignment Status
A=Assign
C=Complete
I=Interview
P=Propose
R=Reject
S=Reserve
V=Pending Approval
X=Cancel
Prompt Table: RS_ASSGN_ST_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	ASSIGN_STS	Character(2)	VARCHAR2(2) NOT NULL	Assignment Status A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel Prompt Table: RS_ASSGN_ST_TBL