HRS_DM_ACHVM_VW (SQL View)	Index Back
Achievements Table Retrieves Honors and accomplishments from the accomplishmetn Table

HRS_DM_ACHVM_VW

(SQL View)

Achievements Table

Retrieves Honors and accomplishments from the accomplishmetn Table

SELECT A.ACCOMPLISHMENT , A.DESCR , A.DESCRSHORT ,' ' FROM PS_HRS_ACCOM_TBL_I A WHERE ACCOMP_CATEGORY='HON'

Related Language Record: HRS_DM_ACHVM_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_DM_KEY_NAME Character(50) VARCHAR2(50) NOT NULL Data Mapping Key Name. This is what is shown in value mappings.

2 HRS_DM_DESCR Character(254) VARCHAR2(254) NOT NULL Data Mapping Object Description

3 HRS_DM_FKEY Character(30) VARCHAR2(30) NOT NULL Data Mapping Forigen Key. Used by Data mapping keys to store the key from the forigen table, for use when performing a sync operation.

4 HRS_DM_SUBCAT Character(50) VARCHAR2(50) NOT NULL SubCategory

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_DM_KEY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Data Mapping Key Name. This is what is shown in value mappings.
2	HRS_DM_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Data Mapping Object Description
3	HRS_DM_FKEY	Character(30)	VARCHAR2(30) NOT NULL	Data Mapping Forigen Key. Used by Data mapping keys to store the key from the forigen table, for use when performing a sync operation.
4	HRS_DM_SUBCAT	Character(50)	VARCHAR2(50) NOT NULL	SubCategory