HRS_ACTYPE_I

(SQL View)
Index Back

SELECT HRS_ACTYPE_ID , HRS_ACTYPE_NAME , HRS_ACTYPE_DESCR , HRS_ACTYPE_STATUS , HRS_APPCLASSNAME , HRS_ACVERIFY_ID FROM PS_HRS_ACTYPE

  • Related Language Record: HRS_ACTYPE_LNI
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_ACTYPE_ID Character(25) VARCHAR2(25) NOT NULL Application Class Type ID
    2 HRS_ACTYPE_NAME Character(30) VARCHAR2(30) NOT NULL Application Class Type Name
    3 HRS_ACTYPE_DESCR Character(254) VARCHAR2(254) NOT NULL Application Class Type Descr
    4 HRS_ACTYPE_STATUS Character(3) VARCHAR2(3) NOT NULL Status
    10=Active
    20=Deprecated
    30=In Progress
    40=Retired

    Default Value: 30

    5 HRS_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: HRS_APPCLASS_PT

    6 HRS_ACVERIFY_ID Character(25) VARCHAR2(25) NOT NULL Verification Class

    Prompt Table: HRS_ACVERIFY_PT