FGHR036_3_AET

(SQL Table)
Index Back

State record for FGHR036

State record for Automatic Leave Enrollment, store the rank for criteria here, add criteria fields as required

# 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 GVT_TMP_NUM1 Number(8,2) DECIMAL(7,2) NOT NULL Temporary Num Storage 1
5 GVT_TMP_NUM2 Number(8,2) DECIMAL(7,2) NOT NULL Generic Field for storing temporaray number
6 GVT_TMP_NUM3 Number(8,2) DECIMAL(7,2) NOT NULL Generic Field for storing temporaray number
7 GVT_TMP_NUM4 Number(8,2) DECIMAL(7,2) NOT NULL Generic Field for storing temporaray number
8 GVT_TMP_NUM5 Number(8,2) DECIMAL(7,2) NOT NULL Generic Field for storing temporaray number
9 GVT_TMP_NUM6 Number(8,2) DECIMAL(7,2) NOT NULL Generic Field for storing temporaray number