PSOPRALIASFIELD

 index back

Operator Alias Fieldnames

An Operator can have corresponding aliases in other application tables -like, PERSONAL_DATA.EMPLID, VENDOR.VENDOR_ID, CONTACT.CONTACT_ID. This table creates these relationships.

PeopleSoft Field Name Field Type Column Type Description
OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type

Prompt Table: PSOPRALIASTYPE

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

Prompt Table: PSDBFIELDNAMEVW

FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSFIELDRECDVW

FIELDNAME_DESCR Character(18) VARCHAR2(18) NOT NULL Description Fieldname

Prompt Table: PSRECFIELDALL

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