GPBR_SORTID

(SQL Table)
 Index Back

Sequence Print Payslip

Sequence Print Payslip - GP Brazil

  • Related Language Record: GPBR_SORTID_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_SORTID Character(10) VARCHAR2(10) NOT NULL SORT ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 GPBR_SEQ01 Character(4) VARCHAR2(4) NOT NULL Order 01
    0010=Company
    0020=Pay Group
    0030=Pay Entity
    0040=Location
    0050=Department
    0060=Supervisor Code
    0070=Employee Type
    0080=Employee ID
    0090=Employee Name
    0100=Establishment
    7 GPBR_ASC_DESC01 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 01

    Y/N Table Edit

    Default Value: N

    8 GPBR_SEQ02 Character(4) VARCHAR2(4) NOT NULL Order 02
    0010=Company
    0020=Pay Group
    0030=Pay Entity
    0040=Location
    0050=Department
    0060=Supervisor Code
    0070=Employee Type
    0080=Employee ID
    0090=Employee Name
    0100=Establishment
    9 GPBR_ASC_DESC02 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 02

    Y/N Table Edit

    Default Value: N

    10 GPBR_SEQ03 Character(4) VARCHAR2(4) NOT NULL Order 03
    0010=Company
    0020=Pay Group
    0030=Pay Entity
    0040=Location
    0050=Department
    0060=Supervisor Code
    0070=Employee Type
    0080=Employee ID
    0090=Employee Name
    0100=Establishment
    11 GPBR_ASC_DESC03 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 03

    Y/N Table Edit

    Default Value: N

    12 GPBR_SEQ04 Character(4) VARCHAR2(4) NOT NULL Order 04
    0010=Company
    0020=Pay Group
    0030=Pay Entity
    0040=Location
    0050=Department
    0060=Supervisor Code
    0070=Employee Type
    0080=Employee ID
    0090=Employee Name
    0100=Establishment
    13 GPBR_ASC_DESC04 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 04

    Y/N Table Edit

    Default Value: N

    14 GPBR_SEQ05 Character(4) VARCHAR2(4) NOT NULL Order 05
    0010=Company
    0020=Pay Group
    0030=Pay Entity
    0040=Location
    0050=Department
    0060=Supervisor Code
    0070=Employee Type
    0080=Employee ID
    0090=Employee Name
    0100=Establishment
    15 GPBR_ASC_DESC05 Character(1) VARCHAR2(1) NOT NULL Ascending or Descending 05

    Y/N Table Edit

    Default Value: N