PSOPRALIASFIELD

(SQL Table)
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 PeopleSoft Field Type Database Column Type Description
1 OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type

Prompt Table: PSOPRALIASTYPE

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

Prompt Table: PSDBFIELDNAMEVW

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

Prompt Table: PSFIELDRECDVW

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

Prompt Table: PSRECFIELDALL