PSIBTEMPLPARAM

(SQL Table)
Index Back

Application Service parameters

IB Application Services parameters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIBAPPLNAME Character(30) VARCHAR2(30) NOT NULL Application Service ID. (see PSIBAPPLDEFN).
2 PTIBAPPLOPR Character(30) VARCHAR2(30) NOT NULL Application Service Opr ID
3 IB_URI_SEQ Number(5,0) INTEGER NOT NULL Sequence Number
4 PARAM_NAME Character(50) VARCHAR2(50) NOT NULL Name
5 PTIBTMPLDTYPE Character(4) VARCHAR2(4) NOT NULL Template Parameter Data Type
BOL=Boolean
DATE=Date
DEC=Decimal
INT=Integer
STR=String
TIME=Time
6 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
7 PT_PARMLENGTH Number(5,0) INTEGER NOT NULL Parameter Length
8 PT_PARMDECLENGTH Number(3,0) SMALLINT NOT NULL Decimal Length
9 PT_COLLECTION Number(3,0) SMALLINT NOT NULL Collection