ALLOC_GROUP_TBL

(SQL Table)
 Index Back

Allocation Process Group

  • Related Language Record: ALLOC_GRP_LANG

  • Parent Record Of ALC_GRSTP_G ALC_GRSTP_TAO ALLOC_GRSTP_AET ALLOC_GRSTP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    3 VERSION_GRP Number(3,0) SMALLINT NOT NULL Group Version

    Default Value: 0

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRLONG Long Character CLOB Long Description
    8 BUDGET_COPY Character(1) VARCHAR2(1) NOT NULL Budget Copy Flag

    Y/N Table Edit

    Default Value: N

    9 DEPLOYED Character(1) VARCHAR2(1) NOT NULL Identify whether an element has been deployed or not.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N