LM_CT_IMPORT_VW

(SQL View)
Index Back

Import Classes

Import Classes

SELECT HRS_APPCLASS_ID , HRS_APPCLASS_NAME FROM PS_HRS_APPCLASS WHERE HRS_ACTYPE_ID='ACTYPE_20051108030323' AND (HRS_APPCLASS_STS='10' OR HRS_APPCLASS_STS='20')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_CT_SEL_IMPORT Character(25) VARCHAR2(25) NOT NULL Select Type
10=Generic Import
2 HRS_APPCLASS_NAME Character(30) VARCHAR2(30) NOT NULL Application Class Name