SAD_OLA_NAME_VW

(SQL View)
 Index Back

Admissions Sample Online App.

PIA based Sample Online Application record to capture and display the applicants name.

SELECT 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION_SA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

Prompt Table: NAME_TYPE_TBL

3 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

Default Value: OPR_DEF_TBL_HR.COUNTRY_NM_FORMAT

Prompt Table: NAME_FORMAT_TBL

4 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

Prompt Table: NAME_SUFFIX_TBL

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
8 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
9 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country