SCC_TC_NAME_VW

(SQL View)
 Index Back

Type Ctrl Name


SELECT A.NAME_TYPE , A.NAME_TYPE_DESCR , A.NAME_TYPE_SHORT , A.DATA_TYPE_CD FROM PS_NAME_TYPE_TBL A WHERE A.NAME_TYPE NOT IN ( SELECT B.NAME_TYPE FROM PS_TYPE_CNTL_NAME B WHERE B.TYPE_CONTROL IN ('D','N'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 NAME_TYPE_SHORT Character(15) VARCHAR2(15) NOT NULL Name Type Short
4 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
N=Customer Data
S=Sample Data
Y=System Data

Default Value: N