PSTL_LD_JPN_AET

(SQL Table)
Index Back

PSTL_LD_JPN State Record

Stores temporary information required to run the AE program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
5 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
6 STATE Character(6) VARCHAR2(6) NOT NULL State
7 LOAD_OPT_JPN Character(3) VARCHAR2(3) NOT NULL Allows you to load either All Prefectures or a Selected Prefecture.
ALL=All Prefectures
SEL=Selected Prefecture