SAD_OLA_PDE_VW

(SQL View)
Index Back

Admissions Sample Online App.

PIA based Sample Online Application record to capture and display the applicants personal information - gender.

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 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

Default Value: U