GP_CALGRPR1_AET(SQL Table) |
Index Back |
---|---|
Calendar Run DefinitionGP Calendar Run Definition table. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | CAL_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Calendar Sequence Number |
3 | SEQ_NUM8 | Number(8,0) | INTEGER NOT NULL | Sequence Number |
4 | GP_CAL_GRP_PREFIX | Character(16) | VARCHAR2(16) NOT NULL | Calendar Run Id |
5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
6 | GP_CAL_FREQ_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Calendar Type for auto calendar group creation |
7 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
8 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
9 | GP_CALGRP_NBR | Number(2,0) | SMALLINT NOT NULL | Number of Calendar Groups |
10 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
11 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
12 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
13 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
14 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
15 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
16 | FREQUENCY_ID | Character(5) | VARCHAR2(5) NOT NULL | Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. |
17 | GP_CAL_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Calendar exists
Default Value: N |
18 | GP_PERIOD_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Calendar exists
Default Value: Y |
19 | TRGT_CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar to which retro deltas are targeted or forwarded |
20 | AUTO_CAL_PERIOD_ID | Character(7) | VARCHAR2(7) NOT NULL | Calendar Period ID, this field will be used in Automatic Period/Calendar Creation GP functionality |
21 | GP_CAL_ID_PREFIX | Character(7) | VARCHAR2(7) NOT NULL | Calendar Period ID, this field will be used in Automatic Period/Calendar Creation GP functionality |
22 | AUTO_CAL_UOM | Character(2) | VARCHAR2(2) NOT NULL |
Unit of measure used in automatic period generation
10=Number of Days 20=Number of Months 30=Semimonthly |
23 | REPEAT_FREQUENCY | Number(2,0) | SMALLINT NOT NULL | Units in Period |
24 | PAY_ADJ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type - This field is used in GP Automatic Calendar Creation to specify the type of adjustment of payment date
1=Days From Period End Date 2=Specific Day of the Week |
25 | DAYS_ADJUSTMENT | Signed Number(3,0) | DECIMAL(2) NOT NULL | Days Adjustment |
26 | DAY_OF_WK | Character(1) | VARCHAR2(1) NOT NULL |
Day of the Week
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
27 | PRD_END_DT_PAY_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
This field is used in case that we are paying on an specific day and the day doesn't matches with the Calendar End Date, so we adjust the date one day before or after Period End Dt.
1=On Or Before Period End Date 2=On Or After Period End Date |
28 | HOLIDAY_PAY_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
This field refers to how are we going to adjust the Payment Date if it's a Holiday.
1=Payment Date does not change 2=Payment Date is the day before 3=Payment Date is the day after |
29 | PYE_SELECT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Payee Select Option
A=Active Payees Only B=Active Payees with... C=Active PLUS Payees with... D=All Payees with... L=Listed Payees Only |
30 | PYE_SELECT_PI_IND | Character(1) | VARCHAR2(1) NOT NULL | Positive Input Indicator |
31 | PYE_SELECT_RTO_IND | Character(1) | VARCHAR2(1) NOT NULL | Select Retro Option |
32 | SEL_CRIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Selection Criteria Option
0=Payee List 1=All Active 2=Active with PI 3=Active with Retro Trigger 4=Active with PI or Rto Trigger 5=Active or has PI 6=Active or has Retro Trigger 7=Active or has PI or Rto Trgr 8=All payees with PI 9=All payees with Retro Changes A=All with PI or Retro Trigger |
33 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
34 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
35 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
36 | PRD_FREQ_SUFFIX | Character(1) | VARCHAR2(1) NOT NULL | Use this field to store a period frequency suffix used in automatic period creation to build the complete suffix for Period ID. This field 'defaults' for the first letter of the Frequency selected, but it is editable |
37 | GP_CAL_ID_SUFFIX | Character(8) | VARCHAR2(8) NOT NULL | Calendar Period ID, this field will be used in Automatic Period/Calendar Creation GP functionality |
38 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
39 | WHERE_CLAUSE | Long Character(500) | VARCHAR2(500) | Where Clause |
40 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
41 | CAL_PRD_ID_OFF_CYL | Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GP_CAL_PRD |
42 | AUTO_OFF_CYCLE_ID | Character(16) | VARCHAR2(16) NOT NULL | Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments |