HRS_ACVERIFY_PT

(SQL View)
 Index Back

SELECT A.HRS_APPCLASS_ID , A.HRS_APPCLASS_NAME , A.HRS_APPCLASS_STS , A.HRS_APPCLASS_DESCR FROM PS_HRS_APPCLASS A WHERE A.HRS_ACTYPE_ID='ACTYPE_20040610100001' AND A.HRS_APPCLASS_STS<>'40' AND A.HRS_APPCLASS_STS<>'30'

  • Related Language Record: HRS_ACVERFY_LPT

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