SCC_NAME_TYP_VW

(SQL View)
 Index Back

Unused Name Type View


SELECT DISTINCT A.EMPLID , B.NAME_TYPE , B.ORDER_BY_SEQ , B.NAME_TYPE_DESCR , B.NAME_TYPE_SHORT , B.DATA_TYPE_CD FROM PS_SCC_CUR_NAME_VW A , PS_HCR_NM_TYP_I B WHERE B.NAME_TYPE NOT IN ( SELECT C.NAME_TYPE FROM PS_SCC_CUR_NAME_VW C WHERE C.EMPLID = A.EMPLID AND C.EFF_STATUS = 'A') AND B.NAME_TYPE NOT IN ( SELECT NAME_TYPE FROM PS_TYPE_CNTL_NAME WHERE TYPE_CONTROL IN ('N', 'D', 'P'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

Prompt Table: NAME_TYPE_TBL

3 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order by Sequence
4 NAME_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Name Type
5 NAME_TYPE_SHORT Character(15) VARCHAR2(15) NOT NULL Name Type Short
6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
N=Customer Data
S=Sample Data
Y=System Data