SCC_CAF_ENT_VW

(SQL View)
 Index Back

CAF Entity prompt


SELECT B.RECNAME , A.SCC_ENTITY_ID , A.SCC_ENTITY_NAME , A.SCC_ENTITY_DESCR , A.SCC_APPCLASSNAME , A.SCC_STATUS FROM PS_SCC_ENTITY_REG A , PS_SCC_CAF_RATRHDR B WHERE A.SCC_RECNAME= B.RECNAME OR B.RECNAME IN ( SELECT X.SCC_RECNAME FROM PS_SCC_ETYPE_REC X WHERE A.SCC_ENTITY_TYPE_ID =X.SCC_ENTITY_TYPE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
4 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description
5 SCC_APPCLASSNAME Character(190) VARCHAR2(190) NOT NULL Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID)

Prompt Table: HRS_APPCLASS_PT

6 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Active
I=Inactive