GPFR_TDA_RECORD

(SQL Table)
 Index Back

Rcd Defn Associated to Struct

DADS related record: store the record definition associated to a structure used in the DADS process.

  • Related Language Record: GPFR_TDA_RECLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
    2 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record
    3 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field
    4 GPFR_DA_STATUS Character(1) VARCHAR2(1) NOT NULL DADS related field
    A=Active
    I=Inactive

    Default Value: A

    5 GPFR_DA_OPTION Character(1) VARCHAR2(1) NOT NULL DADS related field
    D=Display Only
    E=Edit
    I=Invisible

    Default Value: E

    6 GPFR_DA_MANDATORY Character(1) VARCHAR2(1) NOT NULL DADs related field

    Y/N Table Edit

    Default Value: N

    7 GPFR_DA_TYPE Character(1) VARCHAR2(1) NOT NULL DADS related field
    F=Fixed
    M=Monetary
    N=Numeric
    T=Text

    Default Value: T

    8 GPFR_DA_LENGTH Number(3,0) SMALLINT NOT NULL DADS related field
    9 GPFR_DA_DECIMAL Number(2,0) SMALLINT NOT NULL DADS related field
    10 GPFR_DA_LBLSRC Character(1) VARCHAR2(1) NOT NULL DADS related field
    1=Data Type
    2=Record
    3=Translate Value
    11 GPFR_DA_DATTYP Character(10) VARCHAR2(10) NOT NULL DADS related field

    Prompt Table: GPFR_DA_DATTYP

    12 GPFR_DA_PROMPT Character(15) VARCHAR2(15) NOT NULL DADS related field

    Prompt Table: RECDEFN_VW

    13 GPFR_DA_PR_KEY Character(15) VARCHAR2(15) NOT NULL DADS related field
    14 GPFR_DA_PR_DESC Character(15) VARCHAR2(15) NOT NULL DADS related field
    15 GPFR_DA_FIELD Character(18) VARCHAR2(18) NOT NULL DADS related field

    Prompt Table: PSDBFIELD_VW

    16 GPFR_DA_DATSRC Character(2) VARCHAR2(2) NOT NULL DADS related field
    0=System-Computed
    1=Accumulator User Key 1
    10=Base
    11=Percent
    12=Rate
    13=Unit
    14=Customer Field1
    15=Customer Field2
    16=Customer Field3
    17=Customer Field4
    18=Customer Field5
    2=Accumulator User Key 2
    3=Accumulator User Key 3
    4=Accumulator User Key 4
    5=Payroll Result Value
    6=Fixed Text
    7=Not Computed
    8=Accumulator User Key 5
    9=Accumulator User Key 6
    17 GPFR_DA_SUMOPT Character(1) VARCHAR2(1) NOT NULL DADS related field
    1=Sum
    2=First
    3=Last