Microsoft Access PRPSR (WBS Elements)

You should read the table from top to bottom to see the order in which the data fields are stored in the data records in the Access database.

Field name is the name of the field in the table. Type shows the field’s attribute and length gives the length of the data field. Text indicates the type of data.

Field name

Type

Length

Text

ARNUMMER

NUMC

6

Archiving run

VSGRUPPE

CHAR

20

Version group

VSNUMMER

CHAR

12

Version key

PRCTR

CHAR

10

Profit center

PRNAM

CHAR

8

Capital investment program

PRPOS

CHAR

24

Item ID

PSPID

CHAR

24

Project definition

POSID

CHAR

24

WBS element

POST1

CHAR

40

Description

POSKI

CHAR

16

Short ID (WBS element)

ERNAM

CHAR

12

Created by

VERNR

NUMC

8

Responsible person (number)

VERNA

CHAR

25

Responsible person (name)

ASTNR

NUMC

8

Applicant (number)

ASTNA

CHAR

25

Applicant (name)

PBUKR

CHAR

4

Company code

PGSBR

CHAR

4

Business area

PKOKR

CHAR

4

Controlling area

PRART

CHAR

2

Project type

PLAKZ

CHAR

1

Planning element ind.

BELKZ

CHAR

1

Account assign. element ind.

FAKKZ

CHAR

1

Billing element ind.

STUFE

NUMC

3

Level

AKOKR

CHAR

4

Required controlling area

AKSTL

CHAR

10

Required cost center

AKTXT

CHAR

40

Reqd cost center description

FKOKR

CHAR

4

Controlling area resp. cost ctr

FKSTL

CHAR

10

Responsible cost center

FKTXT

CHAR

40

Resp. cost center description

FABKL

CHAR

2

Calendar

PSPRI

CHAR

1

Priority

EQUNR

CHAR

18

Equipment number

TPLNR

CHAR

30

Technical location

PWPOS

CUKY

5

Currency

WERKS

CHAR

4

Plant

TXTSP

LANG

1

Language

SLWID

CHAR

7

Key word ID

USR00

CHAR

20

User field 1 (20 char.)

USR01

CHAR

20

User field 2 (20 char.)

USR02

CHAR

10

User field 1 (10 char.)

USR03

CHAR

10

User field 2 (10 char.)

USR04

QUAN

18

User field 1: Quantity

USE04

UNIT

3

User field 1: Unit of measure

USR05

QUAN

18

User field 2: Quantity

USE05

UNIT

3

User field 2: Unit of measure

USR06

CURR

18

User field 1: Value

USE06

CUKY

5

User field 1: Value unit

USR07

CURR

18

User field 2: Value

USE07

CUKY

5

User field 2: Value unit

USR08

DATS

10

User field 1: Date

USR09

DATS

10

User field 2: Date

USR10

CHAR

1

User field 1: Selection

USR11

CHAR

1

User field 2: Selection

CLASF

CHAR

1

Classified

SCOPE

CHAR

5

Object class

XSTAT

CHAR

1

Statistic

TXJCD

CHAR

15

Jurisdiction code

ZSCHM

CHAR

7

Interest calculation profile

IMPRF

CHAR

6

Investment profile

EVGEW

DEC

10

% completion

SUBPR

CHAR

12

Subproject

PSPCODE

CHAR

50

WBS code

PSTRT

DATS

10

Basic start date

ESTRT

DATS

10

Forecast start date

ISTRT

DATS

10

Actual start date

PENDE

DATS

10

Basic finish date

EENDE

DATS

10

Forecast finish date

IENDE

DATS

10

Actual finish date

PDAUR

QUAN

7

Basic duration

EDAUR

QUAN

7

Forecast duration

IDAUR

QUAN

7

Actual duration

IEINH

UNIT

3

Unit

EEINH

UNIT

3

Unit

PEINH

UNIT

3

Unit

PSTRM

DATS

10

Sched. start date (basic)

PETRM

DATS

10

Sched. finish date (basic)

ESTRM

DATS

10

Sched. start date (forecast)

EETRM

DATS

10

Sched. finish date (forecast)

VISTR

DATS

10

Tentative start date

VIEND

DATS

10

Tentative finish date

STATXT

CHAR

40

Status

FRUEHER

QUAN

7

Earlier

SPAETER

QUAN

7

Later

VERZUG

QUAN

7

Delay

VORBEI

QUAN

7

Past

VEINH

UNIT

3

Unit