FORM_TYPE_VW

(SQL View)
 Index Back

Form Type View

Form Type View

SELECT a.form_type ,a.form_type_status ,a.effdt_from ,a.effdt_to ,a.portal_label ,b.portal_label ,a.form_owner_id FROM ps_form_type a , PSPRSMDEFN b WHERE a.portal_name = b.portal_name AND a.portal_objname = b.portal_objname

  • Related Language Record: FORM_TYPE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
    ADV=Remittance Advice Only
    CAV=Check with Separate Advice
    CRA=Crystal Check w/Advice
    CRW=Crystal Check
    CSA=Check over Stub with Advice
    CSO=Check over Stub with Overflow
    EFA=EFT File with Advice
    EFT=EFT File
    SCA=Stub over Check with Advice
    SCO=Stub over Check with Overflow
    2 FORM_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Application Designer Form
    D=In Design
    E=Edit Fluid Requisition Form
    F=Fluid Supplemental Data Form
    I=Inactivated
    S=Supplemental Data Form

    Default Value: D

    3 EFFDT_FROM Date(10) DATE Effective Date From
    4 EFFDT_TO Date(10) DATE Effective Date To
    5 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    6 PORTAL_LABEL1 Character(30) VARCHAR2(30) NOT NULL Label 1
    7 FORM_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner Id