SCC_EDS_VW

(SQL View)
 Index Back

SELECT a.SCC_ENTITY_ID , a.SCC_STATUS , a.SCC_ENT_LOCK , a.SCC_ENTITY_NAME , a.SCC_ENTITY_TYPE_ID , a.SCC_ENTITY_DESCR , a.SCC_APPCLASSNAME , a.SCC_RECNAME , a.SCC_STG_RECNAME , a.SCC_ELEMENT_NAME , a.SCC_APPLY_UPD_RULE , a.SCC_ENTITY_MSG ,a.SCC_ENT_PT_AUDIT , %subrec(SCC_AUDIT_SBR, a) FROM PS_SCC_ENTITY_REG a WHERE A.SCC_ENTITY_TYPE_ID='SCC_ETYPE_20130116133604'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
2 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Active
I=Inactive

Default Value: A

3 SCC_ENT_LOCK Number(1,0) SMALLINT NOT NULL Lock

Default Value: 9

4 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name
5 SCC_ENTITY_TYPE_ID Character(40) VARCHAR2(40) NOT NULL Entity Type ID

Prompt Table: SCC_ENTITY_TYPE

6 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description
7 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: SCC_APPCLASS_PT

8 SCC_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

Prompt Table: SCC_REC_PT

9 SCC_STG_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

Prompt Table: SCC_REC_PT

10 SCC_ELEMENT_NAME Character(30) VARCHAR2(30) NOT NULL Element Name
11 SCC_APPLY_UPD_RULE Character(1) VARCHAR2(1) NOT NULL Apply Data Update Rule

Y/N Table Edit

Default Value: N

12 SCC_ENTITY_MSG Character(60) VARCHAR2(60) NOT NULL Related IB Message

Prompt Table: SCC_MSGVER_PT

13 SCC_ENT_PT_AUDIT Character(1) VARCHAR2(1) NOT NULL Denotes if Peopletools auditing should be done for an entity.
14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time