GPBR_NRP_MAS_VW

(SQL View)
 Index Back

Run Control Mass Vacations

Run Control Mass Vacations Brazil

SELECT OPRID ,RUN_CNTL_ID ,GPBR_MASS_ABS_ID ,EFFDT ,CANCEL ,PIN_TAKE_NUM + 50000000 ,ABS_BGN_DT ,GPBR_DAYS ,ABS_END_DT ,GPBR_LEAVE_STATUS ,GPBR_13TH_ADVANCE ,GB_GROUP_ID ,ABSENCE_TYPE ,ABSENCE_REASON ,GPBR_REMAINING_BAL ,COMMENTS ,GPBR_PIN_TAKE_NUM + 50000000 FROM PS_GPBR_RC_MASSVAC

  • Parent record: GPBR_RC_MASVA_H

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 GPBR_MASS_ABS_ID Character(10) VARCHAR2(10) NOT NULL Mass Vacation ID Brazil
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 CANCEL Character(1) VARCHAR2(1) NOT NULL Cancel

    Y/N Table Edit

    Default Value: N

    6 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

    Prompt Table: GPBR_ABSTK_VW

    7 ABS_BGN_DT Date(10) DATE NOT NULL Absence Begin Date
    8 GPBR_DAYS Number(3,0) SMALLINT NOT NULL Days
    9 ABS_END_DT Date(10) DATE NOT NULL Absence End Date
    10 GPBR_LEAVE_STATUS Character(2) VARCHAR2(2) NOT NULL Leave Status
    01=Programmed
    03=Calculated
    04=Confirmed
    05=Cancelled
    06=Closed

    Default Value: 01

    11 GPBR_13TH_ADVANCE Number(1,0) SMALLINT NOT NULL Advance payment 13th Month

    1/0 Table Edit (1=True, 0=False)

    12 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    13 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type
    14 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason

    Prompt Table: GP_ABS_REASON

    15 GPBR_REMAINING_BAL Character(2) VARCHAR2(2) NOT NULL Remaining Balance Used in Mass Vacation
    10=Paid
    20=Returns
    30=Maintain Balance

    Default Value: 10

    16 COMMENTS Long Character CLOB Comment
    17 GPBR_PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take Proportional Brazil

    Prompt Table: GP_PIN_AE5_VW