AV_ACCOUNT_TBL

(SQL Table)
Index Back

Account Designation Table

Account Designation Table

  • Related Language Record: AVACCOUNTTBLLN
  • Parent Record Of AV_ACCOUNT_CAF AV_ORIG_DNR_TBL AV_TRIB_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: AV_OPR_DEF_TBL.SETID

    Prompt Table: SETID_TBL

    2 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %DATE

    4 AV_DES_NAME Character(30) VARCHAR2(30) NOT NULL Designation Name
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Account Type
    $=Issue Check
    C=Checking
    L=Liability
    N=Non Applicable
    S=Savings
    X=Expense
    7 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: AV_ITEM_TYPE_VW

    8 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL_VW

    9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: AV_DEPT_VW

    10 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    11 DESCR60_SRCH Character(60) VARCHAR2(60) NOT NULL Formal Description

    Default Value: AV_ACCOUNT_TBL.AV_DES_NAME

    12 AV_CASE_TYPE Character(4) VARCHAR2(4) NOT NULL CASE Type
    C=Current Unrestricted
    E=Endowment & Similar
    L=Loan Funds
    N=Non-Gift
    P=Plant Funds
    R=Current Restricted
    13 AV_CASE_PRPS Character(4) VARCHAR2(4) NOT NULL CASE Purpose
    A=Financial Aid
    B=Land & Buildings
    C=Chairs
    E=Equipment
    F=Faculty/Staff Compen
    J=Student Projects
    L=Library
    M=Academic Divisions
    N=Non-Gift
    O=Other Restricted Purposes
    P=Prizes
    R=Research
    S=Special Programs
    T=Athletics
    U=Unrestricted
    X=Public Service & Ext
    14 AV_FASB_TYPE Character(4) VARCHAR2(4) NOT NULL FASB Type
    1=Unrestricted
    2=Temp. Restricted
    3=Perm. Restricted
    4=Agency
    15 AV_MTCH_GFT_TP Character(6) VARCHAR2(6) NOT NULL Matching Gift Type

    Prompt Table: AV_MTCH_GFT_TBL

    16 AV_INST_TYPE Character(6) VARCHAR2(6) NOT NULL Designation Type

    Prompt Table: AV_INST_TYP_TBL

    17 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

    Prompt Table: AV_STAFF_ST2_VW

    18 GIFT_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

    Prompt Table: EVNT_3CS_TBL

    19 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role

    Prompt Table: AV_PRPS_VW

    20 PLDG_EVENT_3CS Character(10) VARCHAR2(10) NOT NULL Event ID

    Prompt Table: EVNT_3CS_TBL

    21 PLDG_PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Purpose Code

    Prompt Table: AV_PRPS_VW

    22 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    23 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    24 COMMENTS Long Character CLOB Comment