RUN_SF1219

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
5	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code Prompt Table: AGENCY_LOC_CD
6	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DETL_VW
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: CAL_DETP_FY_VW
8	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. Prompt Table: CAL_DETP_PER_VW
9	ACCTG_CLOSE_DT	Date(10)	DATE	Accounting Close Date Default Value: %date
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	PHONE_NUM	Character(12)	VARCHAR2(12) NOT NULL	Phone Number
13	SUPPLMNT_NUM	Number(1,0)	SMALLINT NOT NULL	Supplemental Number used by the flatfile SF1219_1220.