TL_TIME_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
5 PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies the type of time period, which impacts the parameters used to define the time period as well as the logic used to generate the resulting calendar.
CO=Complex
FD=Daily
FM=Monthly
FW=Weekly
RE=Repeating
6 PERIOD_LENGTH Number(3,0) SMALLINT NOT NULL Period Length in Days
7 OFFSET_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Days Offset from Period End
8 SUBTYPE_IND Character(2) VARCHAR2(2) NOT NULL Field defines the valid sub-types available for Time & Labor period types.
M=Month
Q=Quarter
SM=Semi-month
SY=Semi-year
X=User Defined
Y=Year
9 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator
10 START_DAY_OF_WEEK Character(1) VARCHAR2(1) NOT NULL Start Day of Week
1=1 - Monday
2=2 - Tuesday
3=3 - Wednesday
4=4 - Thursday
5=5 - Friday
6=6 - Saturday
7=7 - Sunday
11 START_WEEK_DAY_IND Character(1) VARCHAR2(1) NOT NULL Start Before Start Date
12 START_DT Date(10) DATE Start Date
13 END_DT Date(10) DATE end date
14 TIME_RECORDED Time(15) TIMESTAMP Time Recorded
15 PERIOD_SEQUENCE Number(10,0) DECIMAL(10) NOT NULL Sequence Number of Period ID