SPB_ROLE_TYPE (SQL Table)	Index Back
Role type table Role type table 03/22/11 SMO 11635747 Ensured that matching exceptions are not displayed for invoice linked to purchase orders and workorder.

SPB_ROLE_TYPE

(SQL Table)

Role type table

Role type table 03/22/11 SMO 11635747 Ensured that matching exceptions are not displayed for invoice linked to purchase orders and workorder.

Related Language Record: SPB_ROLETYP_LNG

Parent Record Of SPB_RLTY_DFALRT SPB_ROLE_TASKGP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator

3 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource

4 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
Prompt Table: SPB_CATG_CD_VW1
Set Control Field: SETID

5 MINIMUM Number(3,0) SMALLINT NOT NULL Minimum

6 MAXIMUM Number(3,0) SMALLINT NOT NULL Maximum

7 SP_SCORE Number(7,2) DECIMAL(6,2) NOT NULL Score

8 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: ACCOUNT_EXP_VW

9 ACCOUNT2 Character(10) VARCHAR2(10) NOT NULL Default Labor Account
Prompt Table: ACCOUNT_EXP_VW

10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 SP_TIME_REPORT_OPT Character(1) VARCHAR2(1) NOT NULL Time Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
Default Value: D

13 SP_EXP_REPORT_OPT Character(1) VARCHAR2(1) NOT NULL Expense Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
Default Value: D

14 SPA_USE_EXPENSES Character(1) VARCHAR2(1) NOT NULL Field to indicate if the expenses is allowed in the transcation or not.
D=Default from Business Unit
N=No
Y=Yes
Default Value: D

15 SP_MANDATORY_FLG Character(1) VARCHAR2(1) NOT NULL Survey is mandatory for work order flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

16 SP_AUTO_SUR_FLAG Character(1) VARCHAR2(1) NOT NULL Automatically send Survey to distribution list role actions
N=No
Y=Yes
Y/N Table Edit
Default Value: N

17 SP_TRACK_RESRC Character(1) VARCHAR2(1) NOT NULL Track Resource
B=Default From Business Unit
N=No
Y=Yes

18 SP_USE_WO_ALERTS Character(1) VARCHAR2(1) NOT NULL Using Work Order Alerts flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

19 WO_NOTIFY_BY Character(2) VARCHAR2(2) NOT NULL WorkOrder Alert Notification Method
EM=Email and Worklist
WL=Worklist Only

20 EXTEND_TXN_FLAG Character(1) VARCHAR2(1) NOT NULL EXTEND_TXN_FLAG - May extend flag
B=Default from Business Unit
N=No
Y=Yes
Default Value: B

21 SP_TOL_PCT_OVER Number(6,2) DECIMAL(5,2) NOT NULL 03/22/11 SMO 11635747 Ensured that matching exceptions are not displayed for invoice linked to purchase orders and workorder.

22 SP_TOL_PCT_UNDER Number(6,2) DECIMAL(5,2) NOT NULL 03/22/11 SMO 11635747 Ensured that matching exceptions are not displayed for invoice linked to purchase orders and workorder.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	ROLE_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Service Type APR=Approver MGR=Manager OPR=Operator
3	SERVICE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Service Method D=Deliverable M=Multi Resource R=Resource
4	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code Prompt Table: SPB_CATG_CD_VW1 Set Control Field: SETID
5	MINIMUM	Number(3,0)	SMALLINT NOT NULL	Minimum
6	MAXIMUM	Number(3,0)	SMALLINT NOT NULL	Maximum
7	SP_SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Score
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: ACCOUNT_EXP_VW
9	ACCOUNT2	Character(10)	VARCHAR2(10) NOT NULL	Default Labor Account Prompt Table: ACCOUNT_EXP_VW
10	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	SP_TIME_REPORT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Time Reporting Option A=Actual Allocation D=Default from Business Unit P=Percent Allocation Default Value: D
13	SP_EXP_REPORT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Expense Reporting Option A=Actual Allocation D=Default from Business Unit P=Percent Allocation Default Value: D
14	SPA_USE_EXPENSES	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate if the expenses is allowed in the transcation or not. D=Default from Business Unit N=No Y=Yes Default Value: D
15	SP_MANDATORY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Survey is mandatory for work order flag N=No Y=Yes Y/N Table Edit Default Value: N
16	SP_AUTO_SUR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Automatically send Survey to distribution list role actions N=No Y=Yes Y/N Table Edit Default Value: N
17	SP_TRACK_RESRC	Character(1)	VARCHAR2(1) NOT NULL	Track Resource B=Default From Business Unit N=No Y=Yes
18	SP_USE_WO_ALERTS	Character(1)	VARCHAR2(1) NOT NULL	Using Work Order Alerts flag N=No Y=Yes Y/N Table Edit Default Value: N
19	WO_NOTIFY_BY	Character(2)	VARCHAR2(2) NOT NULL	WorkOrder Alert Notification Method EM=Email and Worklist WL=Worklist Only
20	EXTEND_TXN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	EXTEND_TXN_FLAG - May extend flag B=Default from Business Unit N=No Y=Yes Default Value: B
21	SP_TOL_PCT_OVER	Number(6,2)	DECIMAL(5,2) NOT NULL	03/22/11 SMO 11635747 Ensured that matching exceptions are not displayed for invoice linked to purchase orders and workorder.
22	SP_TOL_PCT_UNDER	Number(6,2)	DECIMAL(5,2) NOT NULL	03/22/11 SMO 11635747 Ensured that matching exceptions are not displayed for invoice linked to purchase orders and workorder.