HR_RFW_VARIABLE

(SQL Table)
 Index Back

Variable Table

Variable Table

  • Related Language Record: HR_RFW_VAR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRRFW_VARNAME Character(15) VARCHAR2(15) NOT NULL Variable Name
    2 HRRFW_DATATYPE Character(4) VARCHAR2(4) NOT NULL Variable Type
    CHAR=Character
    DATE=Date
    DTTM=Datetime
    NUMR=Number
    TIME=Time
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCRLONG Long Character CLOB Long Description
    6 HRRFW_SYSVAR_SRC Character(1) VARCHAR2(1) NOT NULL System Variable Source
    C=Constant
    D=Database Field
    P=PeopleCode
    S=System Computed

    Default Value: S

    7 VALUE_TEXT Character(254) VARCHAR2(254) NOT NULL Value
    8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: HR_RFW_REC_VW

    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HR_RFW_RFD_VW

    10 HRRFW_SETID_IND Character(1) VARCHAR2(1) NOT NULL Set ID Indicator

    Y/N Table Edit

    11 RECNAME_1 Character(15) VARCHAR2(15) NOT NULL Record 1 Name

    Prompt Table: PSRECDEFN

    12 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: HR_RFW_SETID_VW

    13 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
    14 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: HR_RFW_ACL_VW

    15 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: HR_RFW_APH_VW

    16 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N