HRS_APPCLS_SRCH

(SQL View)
 Index Back

Application Class Search


SELECT A.HRS_APPCLASS_ID , A.HRS_APPCLASS_NAME , B.HRS_ACTYPE_NAME , A.HRS_APPCLASS_STS FROM PS_HRS_APPCLASS A , PS_HRS_ACTYPE B WHERE A.HRS_ACTYPE_ID=B.HRS_ACTYPE_ID

  • Related Language Record: HRS_APPCLS_LSCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_APPCLASS_ID Character(25) VARCHAR2(25) NOT NULL Application Class
    2 HRS_APPCLASS_NAME Character(30) VARCHAR2(30) NOT NULL Application Class Name
    3 HRS_ACTYPE_NAME Character(30) VARCHAR2(30) NOT NULL Application Class Type Name
    4 HRS_APPCLASS_STS Character(3) VARCHAR2(3) NOT NULL Status
    10=Active
    20=Deprecated
    30=In Progress
    40=Retired