HR_DIM_RUN_BEL

(SQL Table)
Index Back

DIMONA Run Control Record

DIMONA Run Control Record.

# 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 FROMDATE Date(10) DATE From Date
4 THRUDATE Date(10) DATE End Date

Default Value: %date

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 DIMONA_NR_BEL Character(12) VARCHAR2(12) NOT NULL DIMONA Nr
11 DIMONA_NAME_BEL Character(48) VARCHAR2(48) NOT NULL DIMONA Name
12 DIMONA_SEND_NM_BEL Character(60) VARCHAR2(60) NOT NULL DIMONA Sender name.
13 DIMONA_VERS_BEL Character(3) VARCHAR2(3) NOT NULL DIMONA Version
14 DIMONA_ADDR_BEL Character(45) VARCHAR2(45) NOT NULL DIMONA Address...
15 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
16 POSTAL_NLD Character(7) VARCHAR2(7) NOT NULL Postal Code
17 DIMONA_COUNCIL_BEL Character(35) VARCHAR2(35) NOT NULL Council
18 DIMONA_LAND_CD_BEL Character(5) VARCHAR2(5) NOT NULL DIMONA Country Code
19 DIMONA_CTCT_BEL Character(32) VARCHAR2(32) NOT NULL DIMONA Contact Person.
20 DIMONA_FUNC_BEL Character(30) VARCHAR2(30) NOT NULL DIMONA Contact Function...
21 DIMONA_TEL_BEL Character(20) VARCHAR2(20) NOT NULL DIMONA Tel.
22 DIMONA_SENDER_BEL Character(6) VARCHAR2(6) NOT NULL Belgium Functionality: DIMONA (RSZ) Sender Identification
23 DIMONA_RESTART_BEL Character(1) VARCHAR2(1) NOT NULL Restart DIMONA Notification.

Y/N Table Edit

Default Value: N

24 DIMONA_START_BEL Character(1) VARCHAR2(1) NOT NULL DIMONA Start File

Y/N Table Edit

Default Value: N

25 START_DATE Date(10) DATE Start Date for Gen Standing PO
26 DIMONA_COMMENT_BEL Character(20) VARCHAR2(20) NOT NULL DIMONA User Comment