PTROLENMALIAS_V

index back

SELECT ROLENAME , PTROLENAMEALIAS , 1 FROM PS_PTROLENAMEALIAS UNION SELECT PTROLENAMEALIAS , ROLENAME , 2 FROM PS_PTROLENAMEALIAS

PeopleSoft Field Name Field Type Column Type Description
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Default: PSROLEDEFN.ROLENAME

Prompt Table: PSROLEDEFN

PTROLENAMEALIAS Character(30) VARCHAR2(30) NOT NULL Role Name Alias

Prompt Table: PSROLEDEFN

SELECTTYPE Number(1,0) SMALLINT NOT NULL Selection Type

Default: 1

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20