GP_NRP_ASS_VW

(SQL View)
 Index Back

Packager view of GP_ABS_SS

Non-rule packager view of GP_ABS_SS

SELECT COUNTRY ,PIN_TAKE_NUM + 50000000 ,EFFDT ,EFF_STATUS ,UNIT_TYPE ,LEAVE_HIST_IND ,REQUEST_IND ,CALC_END_DT ,EXCL_HOLIDAYS ,EXCL_NON_WORK ,DISP_USER_FIELDS ,ABS_USER_FLD1_LBL ,ABS_USER_FLD2_LBL ,ABS_USER_FLD3_LBL ,ABS_USER_FLD4_LBL ,ABS_USER_FLD5_LBL ,ABS_USER_FLD6_LBL ,ABS_USER_FLD7_LBL ,ABS_USER_FLD8_LBL ,ABS_USER_FLD9_LBL ,ABS_USER_FLD10_LBL ,ABS_USER_FLD11_LBL ,ABS_USER_FLD12_LBL ,ABS_USER_FLD13_LBL ,ABS_USER_FLD14_LBL ,ABS_USER_FLD15_LBL ,ABS_USER_FLD16_LBL ,REQUIRED_CONFIG1 ,REQUIRED_CONFIG2 ,REQUIRED_CONFIG3 ,REQUIRED_CONFIG4 ,REQUIRED_CONFIG5 ,REQUIRED_CONFIG6 ,REQUIRED_CONFIG7 ,REQUIRED_CONFIG8 ,REQUIRED_CONFIG9 ,REQUIRED_CONFIG10 ,REQUIRED_CONFIG11 ,REQUIRED_CONFIG12 ,REQUIRED_CONFIG13 ,REQUIRED_CONFIG14 ,REQUIRED_CONFIG15 ,REQUIRED_CONFIG16 ,ABS_UF1_SEQ_NUM ,ABS_UF2_SEQ_NUM ,ABS_UF3_SEQ_NUM ,ABS_UF4_SEQ_NUM ,ABS_UF5_SEQ_NUM ,ABS_UF6_SEQ_NUM ,ABS_UF7_SEQ_NUM ,ABS_UF8_SEQ_NUM ,ABS_UF9_SEQ_NUM ,ABS_UF10_SEQ_NUM ,ABS_UF11_SEQ_NUM ,ABS_UF12_SEQ_NUM ,ABS_UF13_SEQ_NUM ,ABS_UF14_SEQ_NUM ,ABS_UF15_SEQ_NUM ,ABS_UF16_SEQ_NUM ,DISPLAY_ORDER ,RQST_ALLOWED_BY ,DISP_CURR_BAL ,CURR_BAL_ACCUM + 50000000 ,BAL_ACCUM_DISP_OPT ,DISPLAY_REASON ,REASON_REQUIRED ,ALLOW_PARTIAL_DAYS ,PARTIAL_DAYS_OPTN ,FCST_IND ,FCST_REQ_SUBMIT ,FCST_REQ_APPROVAL ,FCST_REQ_SBMT_ROLE ,FCST_REQ_APPR_ROLE ,FCST_MESSAGE ,SUBMIT_WITH_WARN ,SUBMIT_WITH_ERROR ,WARN_SUBMT_BY_ROLE ,ERR_SUBMT_BY_ROLE ,CALC_DURATION ,END_DT_DURATN_RULE ,EOAWPRCS_ID ,EOAWDEFN_ID ,CANCEL_OPTION ,START_END_HOL_RULE ,START_END_OFF_RULE ,REQUEST_AS ,OVERRIDE_FLG ,DISPLAY_ORIG_BGN_D ,ABS_TL_ENTRY_IND ,ALLOW_TIME_ENTRY ,ALLOW_EA_ENTRY ,ALLOW_EODI_ENTRY ,HGA_CANCEL_PRCS_ID ,HGA_CANCEL_DEFN_ID ,HGA_CAN_REQ_AS ,HGA_CAN_ALLOW_BY ,HGA_CAN_OVERRIDE ,HGA_CANCEL_OPTN ,HGA_DISP_CAN_RSN ,HGA_APPR_FOR_PND ,HGA_CAN_RSN_REQ ,HGA_EMP_AUTH_REQ ,HGA_OVRD_EMP_AUTH FROM PS_GP_ABS_SS

  • Related Language Record: GP_NRP_ASS_L_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

    Prompt Table: GP_PIN_AT0_VW

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
    D=Days
    H=Hours

    Default Value: D

    6 LEAVE_HIST_IND Character(1) VARCHAR2(1) NOT NULL This fields indicates wheter the Leave History Transactions are allowed in the Self Service Absences Pages
    N=No
    Y=Yes
    7 REQUEST_IND Character(1) VARCHAR2(1) NOT NULL This fields indicates if the country is allowed to add new Leave Request in the Self Service Absences Pages
    N=No
    Y=Yes
    8 CALC_END_DT Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date will be calculated in the Self Service absence entry page
    N=No
    Y=Yes

    Default Value: N

    9 EXCL_HOLIDAYS Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date calculation needs to substract holidays
    N=No
    Y=Yes

    Default Value: N

    10 EXCL_NON_WORK Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date calculation needs to substract days off
    N=No
    Y=Yes

    Default Value: N

    11 DISP_USER_FIELDS Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether or not to display the user fields in the entitlement.
    12 ABS_USER_FLD1_LBL Character(30) VARCHAR2(30) NOT NULL User Field 1-Label, this label will be displayed in the Self Service Absences Transactions Pages
    13 ABS_USER_FLD2_LBL Character(30) VARCHAR2(30) NOT NULL User Field 2-Label, this label will be displayed in the Self Service Absences Transactions Pages
    14 ABS_USER_FLD3_LBL Character(30) VARCHAR2(30) NOT NULL User Field 3-Label, this label will be displayed in the Self Service Absences Transactions Pages
    15 ABS_USER_FLD4_LBL Character(30) VARCHAR2(30) NOT NULL User Field 4-Label, this label will be displayed in the Self Service Absences Transactions Pages
    16 ABS_USER_FLD5_LBL Character(30) VARCHAR2(30) NOT NULL User Field 5-Label, this label will be displayed in the Self Service Absences Transactions Pages
    17 ABS_USER_FLD6_LBL Character(30) VARCHAR2(30) NOT NULL User Field 6-Label, this label will be displayed in the Self Service Absences Transactions Pages
    18 ABS_USER_FLD7_LBL Character(30) VARCHAR2(30) NOT NULL User Field 7-Label, this label will be displayed in the Self Service Absences Transactions Pages
    19 ABS_USER_FLD8_LBL Character(30) VARCHAR2(30) NOT NULL User Field 8-Label, this label will be displayed in the Self Service Absences Transactions Pages
    20 ABS_USER_FLD9_LBL Character(30) VARCHAR2(30) NOT NULL User Field 9-Label, this label will be displayed in the Self Service Absences Transactions Pages
    21 ABS_USER_FLD10_LBL Character(30) VARCHAR2(30) NOT NULL User Field 10-Label, this label will be displayed in the Self Service Absences Transactions Pages
    22 ABS_USER_FLD11_LBL Character(30) VARCHAR2(30) NOT NULL User Field 11-Label, this label will be displayed in the Self Service Absences Transactions Pages
    23 ABS_USER_FLD12_LBL Character(30) VARCHAR2(30) NOT NULL User Field 12-Label, this label will be displayed in the Self Service Absences Transactions Pages
    24 ABS_USER_FLD13_LBL Character(30) VARCHAR2(30) NOT NULL User Field 13-Label, this label will be displayed in the Self Service Absences Transactions Pages
    25 ABS_USER_FLD14_LBL Character(30) VARCHAR2(30) NOT NULL User Field 14-Label, this label will be displayed in the Self Service Absences Transactions Pages
    26 ABS_USER_FLD15_LBL Character(30) VARCHAR2(30) NOT NULL User Field 15-Label, this label will be displayed in the Self Service Absences Transactions Pages
    27 ABS_USER_FLD16_LBL Character(30) VARCHAR2(30) NOT NULL User Field 16-Label, this label will be displayed in the Self Service Absences Transactions Pages
    28 REQUIRED_CONFIG1 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes

    Default Value: N

    29 REQUIRED_CONFIG2 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes

    Default Value: N

    30 REQUIRED_CONFIG3 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes

    Default Value: N

    31 REQUIRED_CONFIG4 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes

    Default Value: N

    32 REQUIRED_CONFIG5 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    33 REQUIRED_CONFIG6 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    34 REQUIRED_CONFIG7 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    35 REQUIRED_CONFIG8 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    36 REQUIRED_CONFIG9 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    37 REQUIRED_CONFIG10 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    38 REQUIRED_CONFIG11 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    39 REQUIRED_CONFIG12 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    40 REQUIRED_CONFIG13 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    41 REQUIRED_CONFIG14 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    42 REQUIRED_CONFIG15 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    43 REQUIRED_CONFIG16 Character(1) VARCHAR2(1) NOT NULL Indicates if the user field is required
    N=No
    Y=Yes
    44 ABS_UF1_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Character 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    45 ABS_UF2_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Character 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    46 ABS_UF3_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Character 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    47 ABS_UF4_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Character 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    48 ABS_UF5_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Date 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    49 ABS_UF6_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Date 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    50 ABS_UF7_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Date 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    51 ABS_UF8_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Date 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    52 ABS_UF9_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Monetary 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    53 ABS_UF10_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Monetary 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    54 ABS_UF11_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Monetary 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    55 ABS_UF12_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Monetary 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    56 ABS_UF13_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Decimal 1 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    57 ABS_UF14_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Decimal 2 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    58 ABS_UF15_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Decimal 3 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    59 ABS_UF16_SEQ_NUM Number(2,0) SMALLINT NOT NULL User Field Decimal 4 Label Sqn Nbr, this will be used to display the order in the Self Service Absences Transactions Pages
    60 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    61 RQST_ALLOWED_BY Character(1) VARCHAR2(1) NOT NULL This field dictates who can request a specific absence take in self-service.
    A=Administrator
    B=Employee and Manager
    E=Employee
    M=Manager
    62 DISP_CURR_BAL Character(1) VARCHAR2(1) NOT NULL This field indicates whether or not to show the current balance of the entitlement on the self-service pages.
    63 CURR_BAL_ACCUM Number(8,0) INTEGER NOT NULL This field is used to contain the pin number of the accumulator that will represent the current balance of the entitlements.
    64 BAL_ACCUM_DISP_OPT Character(1) VARCHAR2(1) NOT NULL This field will dictate how the current balance will be calculated and displayed on the self-service pages.
    N=Not Summarized
    S=Summarized
    65 DISPLAY_REASON Character(1) VARCHAR2(1) NOT NULL This field is used to determine whether the Absence Reason or Leave Donation Reason fields should display on the self-service pages.
    66 REASON_REQUIRED Character(1) VARCHAR2(1) NOT NULL This field indicates whether the Reason field is required.
    67 ALLOW_PARTIAL_DAYS Character(1) VARCHAR2(1) NOT NULL This field indicates whether partial days are allowed for a particular absence take

    Y/N Table Edit

    Default Value: N

    68 PARTIAL_DAYS_OPTN Character(1) VARCHAR2(1) NOT NULL This field will be used to indicate what types of partial days are allowed
    B=Partial Hours and Half Days
    D=Half Days
    H=Partial Hours
    N=None
    69 FCST_IND Character(1) VARCHAR2(1) NOT NULL This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.
    70 FCST_REQ_SUBMIT Character(1) VARCHAR2(1) NOT NULL This field indicates whether Forecasting is required to submit an absence request.
    71 FCST_REQ_APPROVAL Character(1) VARCHAR2(1) NOT NULL This field indicates whether Forecasting is required to approve an absence request.
    72 FCST_REQ_SBMT_ROLE Character(1) VARCHAR2(1) NOT NULL This field indicates which role is required to Forecast in order to submit an absence request.
    B=Employee and Manager
    E=Employee
    M=Manager
    N=Not Applicable
    73 FCST_REQ_APPR_ROLE Character(1) VARCHAR2(1) NOT NULL This field indicates which role is required to Forecast in order to approve the absence request.
    A=Administrator
    B=Administrator and Manager
    M=Manager
    N=Not Applicable
    74 FCST_MESSAGE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate which type of Forecasting message to use as a result of Forecasting being complete, default message or a customized message.
    C=Customized Message
    D=Default Message
    75 SUBMIT_WITH_WARN Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether a request can be submitted after Forecasting returns a warning message.
    76 SUBMIT_WITH_ERROR Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether an absence request can be submitted after Forecasting returns an error message
    77 WARN_SUBMT_BY_ROLE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate which role is allowed to submit an absence request that has a warning returned by Forecasting.
    B=Employee and Manager
    E=Employee
    M=Manager
    N=Not Applicable
    78 ERR_SUBMT_BY_ROLE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate which role is allowed to approve an absence request that had an error returned after Forecasting is complete.
    A=Administrator
    B=Employee and Manager
    E=Employee
    M=Manager
    N=Not Applicable
    79 CALC_DURATION Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether to calculate the end date, the duration, or both.

    Y/N Table Edit

    Default Value: Y

    80 END_DT_DURATN_RULE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate what rule to apply when both fields (end date and calculation) are available. Which takes field will be calculated if fields have values.
    D=Duration
    E=End Date
    N=Not Applicable
    81 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    82 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    83 CANCEL_OPTION Character(1) VARCHAR2(1) NOT NULL This field is used to indicate what to do with the physical absence record when it is being canceled.
    C=Change Status on Record
    D=Delete From Database
    84 START_END_HOL_RULE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether the start or end date of an absence request can be scheduled for a holiday.
    85 START_END_OFF_RULE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether the start or end date can be scheduled for an off-day
    86 REQUEST_AS Character(1) VARCHAR2(1) NOT NULL This field dictates if the manager can request an absence take as an employee in self-service.
    E=Employee
    M=Manager
    N=Not Applicable

    Default Value: E

    87 OVERRIDE_FLG Character(1) VARCHAR2(1) NOT NULL Override Flag

    Y/N Table Edit

    Default Value: Y

    88 DISPLAY_ORIG_BGN_D Character(1) VARCHAR2(1) NOT NULL This field is used to determine whether the Absence Reason field should display on the self-service pages.

    Y/N Table Edit

    Default Value: N

    89 ABS_TL_ENTRY_IND Character(1) VARCHAR2(1) NOT NULL Absence Management - T/L Entry Indicator
    90 ALLOW_TIME_ENTRY Character(1) VARCHAR2(1) NOT NULL Used to capture the setup data at country and country take on whether the Start and End Time had to be captured
    91 ALLOW_EA_ENTRY Character(1) VARCHAR2(1) NOT NULL Used to capture the setup data at country take on whether a take can be entered as an Extended Absence
    92 ALLOW_EODI_ENTRY Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not an absence can be entered through Desktop Integration.
    93 HGA_CANCEL_PRCS_ID Character(30) VARCHAR2(30) NOT NULL Cancellation Approval Process ID
    94 HGA_CANCEL_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Absence Cancellation Approval Definition ID
    95 HGA_CAN_REQ_AS Character(1) VARCHAR2(1) NOT NULL Cancel Allow As
    E=Employee
    M=Manager
    N=Not Applicable
    96 HGA_CAN_ALLOW_BY Character(1) VARCHAR2(1) NOT NULL Cancel Allowed By
    B=Employee and Manager
    E=Employee
    M=Manager
    97 HGA_CAN_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Cancel As
    98 HGA_CANCEL_OPTN Character(1) VARCHAR2(1) NOT NULL Delete Event option
    1=All Events
    2=All Events Except Processed
    3=All Events Except Finalized
    4=Not Used
    99 HGA_DISP_CAN_RSN Character(1) VARCHAR2(1) NOT NULL Display Cancel Reason
    100 HGA_APPR_FOR_PND Character(1) VARCHAR2(1) NOT NULL Approval Required for pending requests
    101 HGA_CAN_RSN_REQ Character(1) VARCHAR2(1) NOT NULL Cancel Reason Required
    102 HGA_EMP_AUTH_REQ Character(1) VARCHAR2(1) NOT NULL Employee Authorization Required
    103 HGA_OVRD_EMP_AUTH Character(1) VARCHAR2(1) NOT NULL Override Authorization