SP_TRN_ROLE_REG (SQL Table)	Index Back
Trans Role Action Registration System data table that contains the allowed Role Actions for Transactions (e.g. Work Orders) to derive the userid and record/fields tied to the role action.

SP_TRN_ROLE_REG

(SQL Table)

Trans Role Action Registration

System data table that contains the allowed Role Actions for Transactions (e.g. Work Orders) to derive the userid and record/fields tied to the role action.

Related Language Record: SP_TRN_RLRG_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 KEY_01 Character(15) VARCHAR2(15) NOT NULL Key Value 01

2 TRANNAME Character(30) VARCHAR2(30) NOT NULL Transaction Name

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 QRYNAMETEXT Character(30) VARCHAR2(30) NOT NULL Query Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KEY_01	Character(15)	VARCHAR2(15) NOT NULL	Key Value 01
2	TRANNAME	Character(30)	VARCHAR2(30) NOT NULL	Transaction Name
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	QRYNAMETEXT	Character(30)	VARCHAR2(30) NOT NULL	Query Name