PROCESS_INSTANCE10=Number of Days
20=Number of Months
30=Semimonthly
Default Value: 1
GP_AUTO_PRD_AET(SQL Table) |
Index Back |
|---|---|
Automatic Period CreationUse this record to store automatic period creation parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | 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 |
| 5 | 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 |
| 6 | REPEAT_FREQUENCY | Number(2,0) | SMALLINT NOT NULL | Units in Period |
| 7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 10 | 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. |
| 11 | 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 |
| 12 | DUPLICATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Duplicate Flag |