GP_AUTO_PRD

#	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	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
4	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 Default Value: 10
5	REPEAT_FREQUENCY	Number(2,0)	SMALLINT NOT NULL	Units in Period
6	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date Default Value: %date
7	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Default Value: %date
8	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
9	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. Prompt Table: FREQUENCY_TBL
10	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