Organization Chart with Address

A new flat file (text only) has been created to be used by various groups and departments on campus. The flat file contain pieces of information from various locations on the PeopleSoft system that are associated with the Speedtypes.. The information comes from three logical areas. The first is the GL/PeopleSoft data base, the second area is the BYU Person Table, and the third area is the PeopleSoft table that defines the structure of the University's organizational structure.

STFF.DAT is the name of the resulting text file (with the following layout).

Field Name	Type(Size)	Location
BEG-CTRL	CHAR(02)	(001,002)
SPEEDTYPE_CODE	CHAR(10)	(003,012)
SPEEDTYPE_DESCR	CHAR(30)	(013,042)
FUND_CODE	CHAR(06)	(043,048)
FUND_DESCR	CHAR(30)	(049,078)
ORG_CODE	CHAR(06)	(079,084)
ORG_DESCR	CHAR(30)	(085,114)
PROJECT_ID	CHAR(15)	(115,129)
PROJECT_DESCR	CHAR(30)	(130,169)
PROGRAM_CODE	CHAR(05)	(160,164)
PROGRAM_DESCR	CHAR(30)	(165,194)
MANAGER_NAME	CHAR(30)	(195,224)
MANAGER_ID	CHAR(09)	(225,233)
BYU_EMAIL	CHAR(30)	(234,263)
BYU_EXTENTION	CHAR(15)	(264,278)
BYU_LOCATION	CHAR(10)	(279,288)
CONTACT_NAME	CHAR(30)	(289,318)
CONTACT_ID	CHAR(09)	(319,327)
BYU_EMAIL	CHAR(30)	(328,357)
BYU_EXTENTION	CHAR(15)	(358,372)
BYU_LOCATION	CHAR(10)	(373,382)
COLLEGE_DIV_NODE	CHAR(20)	(383,402)
COLLEGE_DIV_DESCR	CHAR(30)	(403,422)
DEPT_NODE	CHAR(20)	(433,452)
DEPT_DESCR	CHAR(30)	(453,482)
FUTURE_USE	CHAR(17)	(483,499)
end of record	CHAR(01)	(500,500)